Monday, March 26, 2012

Retry n times if the source file is not available in the specified location

I have a flat source file(.csv) which I am importing to SQL server. Now, if the source file is not available at the specified location, then the SSIS package should retry to execute n times( say 3 times) after certain time interval. The number of retries and the time interval should be configurable.

I have used Flat File connection manager for the source and OLEDB connection manager for the destination.

I am quite new to SSIS. Any help would be highly appreciated.

You can setup retries in SQL Server Agent which can run your SSIS job.. SSIS doesn't have that kind of logic built in.

With that said, this could be scripted in a Script Task though, using the File.Exists member.

No comments:

Post a Comment