Geek Answers Handbook

How to set a command timeout in SSIS?

I have a datareader source starting some sql that takes more than 30 seconds to start, so it disconnects. I cannot find the command timeout property in the source datareader component or data stream task. Is there a way to set a longer command timeout in SSIS?

+6
ssis
source share
2 answers

Right-click the Datareader source and click Modify. Go to the Component Properties of the tab and in the "Custom Group Properties" section there is CommandTimeout

+10
source share

I see that there is a fix for this, I don’t know whether it applies to you or not: Link to the fix

0
source share

More articles:


All Articles