SSIS detecting file

Last Post 17 Jun 2008 12:57 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
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

thanks

SQLUSA
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: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy