Dynamic Data Flow - Dynamic Column Custom Handler

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 handler method layout.


1
2
3
4
5
6
<DataFlowColumnAdded("OnColumnAdded")> _
Public Class ScriptMain
    Inherits UserComponent
...
    Public Sub OnColumnAdded(ByVal component As IDTSComponentMetaData90, ByVal isInput As Boolean, ByVal colName As String)
…
Make sure that you have set DelayValidation to True in Data Flow Task Plus.