Event Wait in SSIS
-
Monday, December 03, 2012 12:40 PM
In my project, we will get file to FTP location with a batch script. we need to process the file using SSIS.
Here I need to make sure that batch script run successfully and need to run SSIS Package.
For this I need a event wait which will wait till the file placed in FTP location.
I have used WMI EVENT WATCHER TASK for this and it is waiting for the file when run manually. But for scheduled run it is not waiting for the file.
Our client donot want to install any other
Can any one help me out how to do this event wait task in SSIS.
Thanks in advance.
All Replies
-
Thursday, December 06, 2012 3:14 PMchek out below link for examples for event wait.
http://www.simple-talk.com/sql/performance/investigating-sql-server-2008-wait-events-with-xevents/SQL Champ
Database Consultants NY -
Thursday, December 06, 2012 3:22 PMModerator
Hi ravikiransid,
You can use script task to check if the file exists and schedule the package to run at a specified interval. Please see:
http://www.bidn.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis
Thanks,
EileenEileen Zhao
TechNet Community Support- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Wednesday, December 12, 2012 7:21 AM


