How do you set the command timeout in SSIS?
25,857
Right Click on the Datareader source and click edit. Go to Tab Component Properties and under Group Custom Properties has CommandTimeout
Related videos on Youtube
09 : 17
56 SQL Server Configurations in SSIS | SSIS configuration sql server
09 : 48
SSIS Interview Question - Techniques for Performance Tunning SSIS Package Part 1
09 : 36
SSIS Tutorial Part 43 Intro- What is OLE DB Command Transformation ( Quick Demo)
23 : 03
SQL Server Command Timeout - Application Timeout - Attention
07 : 05
SSIS (04): Execute SQL Task, Variable - store the return value as variable
24 : 19
SSIS Tutorial Part 117-Log File Load Time & Record Count(Execute SQL Task Input/Output Parameters)
30 : 11
SSIS - Deployment and Execution - Parameters, Environment
02 : 09
MSSQL - How To Run SSIS From Command Line
03 : 39
SSIS "Execute SQL Task" - simple SQL command
11 : 45
execute ssis package from command line
16 : 51
SSIS Dynamic SQL Command
02 : 36
Execute SQL commands through SSIS
08 : 43
20 DateTime type conversions in SSIS
28 : 50
Azure SSIS Integration Runtime and KingswaySoft
Comments
-
Jeremy almost 2 years
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?
-
Jeremy over 14 yearsAll I have for properties on the Custom Properties group is SqlCommand and UserComponentTypeName
-
Fahad over 14 yearsI am using VS.net 2005. But I think that shouldn't be an issue with VS.net 2008. Its strange that property is missing. Try OLE Db Data Source. See if that has the property.
-
Jeremy over 14 yearsYup, the OLE DB Source has a command timeout, but the DataReader Source does not!
