Implement data flow connection setup when there is an associated script

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 Property Connection() As String
    Get
        Connection = m_connection
    End Get
    Set(ByVal value As String)
        m_connection = value
    End Set
End Property
 
<Browsable(False)> _
Public ReadOnly Property ConnectionType() As String
    Get
        ConnectionType = "OLEDB"
    End Get
End Property


    • Related Articles

    • How to build the data flow setup

      The initialization and user interface for a data flow is defined by implementing properties on the script EntryPoint class. The documentation and samples of Script Task Plus for defining parameters is relevant to the Data Flow Task Plus ...
    • Dynamic Data Flow - Dynamic Column Custom Handler

      To setup custom routine in the data flow script for additional setup of dynamically added data flow column, attribute your script main class with DataFlowColumnAdded attribute. Set as parameter the name of the script method. Check below the required ...
    • Dynamic Data Flow - How to create completely dynamic data flow?

      Starting from 1.4 SR-3 the data flow can be completely dynamic - the need to have one common column across different iteration sets is no longer required. To have completely dynamic components, you have to remove all statically defined columns (both ...
    • 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 ...
    • 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 ...