Sample script to set up the CommandTimeout property of the DataReader Source component
Sample script to set up the CommandTimeout property of the DataReader Source component.
1 2 3 4 5 6 7 8 9 | <DataFlowSetting(New String() {"DataReader Source.Property.CommandTimeout"})> _Public Property CommandTimeout() As Integer Get CommandTimeout = m_commandTimeout End Get Set(ByVal value As Integer) m_commandTimeout = value End SetEnd Property |
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
DataFlowSetting .NET attribute used with Data Flow Task Plus
The DataFlowSetting .NET attribute defines a list of references to different component properties in the SSIS data flow. It defines the link between the initialization parameter and a specific SSIS data flow component parameter. You can apply one ...Sample script to set up a column with ID 3018 in DataReader Output output of DataReader Source component
Sample script to set up a column with ID 3018 in DataReader Output output of DataReader Source component. 1 2 3 4 5 6 7 8 9 <DataFlowSetting(New String() {"DataReader Source.Column.Output.DataReader Output.3018"})> _ Public Property Column() As ...Where can I find scripts for the Script Task Plus and Script Component Plus?
Although no longer supported, scripts for the Script Task Plus can be found at the following link. We are now supporting scripts for JavaScript Task and JavaScript Component instead. JavaScript Task is an SSIS Control Flow Task that allows ...Implement data flow connection setup when there is an associated script
Sample script to set up an IDbConnection connection of the DataReader Source component. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 <Connection("ConnectionType")> _ <DataFlowSetting(New String() {"DataReader Source.Connection.IDbConnection"})> _ Public ...How to upgrade a script in Script Component Plus from 2005 to 2008
How to upgrade a script from 2005 to 2008 In order for this process to work, you must have both SQL 2005 and 2008 installed side-by-side on the same machine. Most of the scripts published in the public script repository are for SQL 2005. However they ...