How can you maintain CommandTimeout in config file
SQL 2005. I have many SSIS packages that read from DB2 using a .Net ODBC Data Provider. They all share a common configuration file, and I would like to control the CommandTimeout property of the Data Reader Source in that configuration file, but I can't figure out how to do that. The SQLCommand property seems to be the only property of the Data Reader Source that's available for setting in the configuration file. It's also the only property that is available for assigning in an expression. Can this be done? Thanks in advanceVern Rabe
July 15th, 2012 2:38pm

Hi Vern, You can set the CommandTimeout Property through your SQL Command property. SQLCommand.CommandTimeout is the property name. If you are unable to set this property directly through the task, the workaround is to assign the property value via a variable in script task and then include the variable value in the package configuration. Hope this helps Thanks Vinaya
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2012 11:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics