CODEWITHSUNDEEP
sql-serverssisetl
J.S.Orris
J.S.Orris

Reputation: 4821

Automatically Run SSIS Package From Where Stopped after Server Connection Timeout

Been working on a SSIS package for a few days now. Server keeps timing out halfway through package execution. I have a ForEach Loop container that is looping through a directory of excel files to import the excel data into SQL Server; there is about 500 files in the directory. This is starting to become very time consuming because my server has been timing out. My question is this:

Is there a script I could write to have this package run from where it left off as the server timed out?

Thanks

Upvotes: 0

Views: 470

Answers (1)

shree.pat18
shree.pat18

Reputation: 21757

You could use Checkpoints to make your package start from where it stopped in the last run. As always, MSDN documentation is a good place to start.

Upvotes: 1

Related Questions