Start DTS when FTP'd file appears

  • I have some dts packages that I would like to start when the text file they use appears in the ftp directory. Is this possible? Anyone have some examples.

    Thanks

  • I dont have sample code handy, but there are a couple ways. One is to just poll the folder in a job, if you find a file, start the package. Or run the package and do the check up front. The Win API has a call that will monitor the folder and return when the folder changes, cleaner than polling but you have to have an app running to host the api call.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 2 (of 2 total)

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