question

dhiruz avatar image
dhiruz asked

SSIS -FTP connection file watcher

hi there, I have a task that i need to find the file with XXX_yyyymmdd_hh24.dat through FTP connection and then have to load that file to SQL server . Here first i have to make sure i have th at find that file (.dat file )using file watcher ,then i have to get that file through FTP and load it into a Staging database on SQL Server .
sql-server-2005ssisftp
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Andy Leonard avatar image
Andy Leonard answered
Hi dhiruz, Some folks advocate running a package in some kind of loop. I've written way too many memory leaks in my time to feel comfortable running a package in a never-ending loop. I advocate either polling the directory at intervals - even 1-minute intervals - or utilizing a scheduler/service/application that will "sniff" the directory for you and fire an SSIS package in response. :{>
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.