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?
Asked
Active
Viewed 2.7k times
7
-
what version of SQL Server are you running? – Anthony Potts Nov 10 '09 at 21:15
2 Answers
11
Right Click on the Datareader source and click edit. Go to Tab Component Properties and under Group Custom Properties has CommandTimeout
Fahad
- 1,261
- 9
- 19
-
All I have for properties on the Custom Properties group is SqlCommand and UserComponentTypeName – Jeremy Nov 10 '09 at 21:57
-
I 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. – Fahad Nov 10 '09 at 22:16
-
Yup, the OLE DB Source has a command timeout, but the DataReader Source does not! – Jeremy Nov 10 '09 at 23:26
0
I see there is a hotfix for this, I don't know if it applies to you or not: Hotfix link
Anthony Potts
- 8,842
- 8
- 41
- 56
-
This says its for the web service task, does it apply to the datareader source component too? – Jeremy Nov 10 '09 at 21:58