February 22, 2012 at 6:09 am
Hi,
I have ForLoop in my control flow which runs for 4 hrs from my starting time
Inside my Forloop i have a datflow in which iam writing data in to a file using script component from the source.
I like to know how to handle the connection time out error and other file related error( iam not aware what kind of error wll occur while writing data in to file)
My package should not fail due to this DB connection time error etc,For ex:It should wait for some time and reconnect again and start the process from the point where it stopped.
Is it possible in SSIS?
Can anyone pls help me.
February 24, 2012 at 12:28 am
You can set the time-out behaviour on the database server, but I would advice not setting it to infinite. It can affect other applications as well and can cause programs to hang forever.
Try using checkpoints in SSIS and implement some restarting mechanism that will restart a package if it fails.
Restarting Failed Packages by Using Checkpoints
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply