I have a datareader source firing some sql which takes longer than 30 seconds to run, so it's timing out. I can not find a command timeout property on the datareader source component, or the data flow task. Is there some way to set a longer command timeout in SSIS?
Right Click on the Datareader source and click edit. Go to Tab Component Properties and under Group Custom Properties has CommandTimeout
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With