New to SSIS..

Question

New to SSIS..

Tony Le Messmer

Newbie

Points: 9
More actions
March 29, 2007 at 10:48 am

#172612

Apologies if this seems like a daft question....
How do I start a package when a new file is received in a certain location?
Many Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Si SSCommitted Points: 1537 More actions · Answer 1

Not sure if it helps but in 2000 you cant easily trigger a job from a file just turning up on your server. However you can set up a job that calls a DTS package with some code in it (we use VB) to check that the file exists. If it does exist it runs the rest of the DTS, if it doesn't it just exits. You could run this so many times an hour to check for the file if you need to.

Nitin Bansal-349869 SSC Enthusiast Points: 115 More actions · Answer 2

you can create a windows service for the same and make it run repeatedly to check for the existence of the file and if its there then call the SSIS package programmatically....

Regards,

Nitin'

Bob McEuen Right there with Babe Points: 791 More actions · Answer 3

Check this link out... http://www.sqlis.com/

You will find a 'File Watcher Task' that you can download and add to your SSIS toolbox that will make this task relatively simple. You can put the file watcher task in a parent package and execute a child package when a file(s) arrives.

Bob McEuen