SSIS detecting file

Last Post 17 Jun 2008 12:57 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

16 Jun 2008 01:23 PM
can SSIS detect when file arrives into directory and then import it into SQL?

for example file comes before 8 : 30 grab it and import into a table file aint here by that time send email?

we dont have biztalk nor Automate to do this i was curious if SSIS can doe it


New Member
New Member

17 Jun 2008 12:57 PM
Eternal looking is better for SQL Server Agent.

You can schedule the SSIS job every 5 minutes. If SSIS finds nothing to do, heads for a quick exit. Otherwise it processes the files.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS:

Acceptable Use Policy