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 initialization parameter to multiple data flow components and properties. Each reference is a text string with separate sections. Each section is separated by a "." dot. Every reference starts with a component, followed by a "keyword" specifying the parameter type. Here is a list of sample DataFlowSetting .NET attribute reference types which are supported currently by the Data Flow Task Plus component:
- DataReader Source.Property.PreCompile - set property PreCompile.
- DataReader Source.Connection.IDbConnection - set connection IDbConnection.
- DataReader Source.Column.Input.DataReader Input.DateKey - set input column DateKey in DataReader Input input.
- DataReader Source.Column.Output.DataReader Output.DateKey - set output column DateKey in DataReader Output output.
- DataReader Source.Column.OutputExternal.DataReader Output.DateKey - set external output column DateKey in DataReader Output output.
where DataReader Source is a reference to a data flow component.
In SSIS, different data flow elements like components, properties, connections, and columns can be referenced either by name or ID. The DataFlowSetting .NET attribute reference supports both.
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 - 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 ...
How to increase the Data Flow Task Plus buffer size?
To increase the Data Flow Task buffer size please complete the following steps: 1) Right-click on the Data Flow Task and select Properties. 2) On the Data Flow Task's Properties screen under Misc find fields: DefaultBufferSize and ...
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 ...
Data Flow Task Plus editor doesn't open
When I double-click on Data Flow Task Plus, the Data Flow Task Plus Editor doesn't open and instead of that I am sent to the Data Flow tab. There is a known issue in Visual Studio when a solution file is opened externally (e.g. from the taskbar ...