July 9, 2007 at 12:00 pm
Hi All,
This may be easier than I think, but I have never even tried it so here it goes.
In our Data warehousing evnironment we run a full back up and restore of our databases to push them out to the production servers for our web application. But before that can be done our data refresh process has to complete and it has to be checked by our ETL software (non SQL Server). Upon completion of the check a text file is written to a shared resource.
What I would like to do is to have a SQL job set up with SSIS(?) to detect the file and then run the other sql jobs for the back up and restore. Then as the last step delete the file to signify that the refresh / roll out is complete.
This is all new to me so any suggestions would be helpful.
July 13, 2007 at 11:29 am
I saw somewhere that there is a "File Watcher" SSIS Component. This would help. However, you could also have the Sql Job just kick off an EXE that runs the SSIS Package. The SSIS package would have a check for the file to exist and process accordingly.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply