DataFlowSetting .NET attribute used with Data Flow Task Plus

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.