Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you set the command timeout in SSIS?

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?

like image 284
Jeremy Avatar asked Nov 10 '09 21:11

Jeremy


1 Answers

Right Click on the Datareader source and click edit. Go to Tab Component Properties and under Group Custom Properties has CommandTimeout

like image 181
Fahad Avatar answered Sep 30 '22 15:09

Fahad