Can I enable a property to be set dynamically from variable using an SSIS Expression?
When using Data Flow Task Plus, sometimes you want to be able to set parameters in the source, transformation or destination components within the data flow, but those parameters are not available by default.
Let's take a look at an example. In this Data Flow Task Plus, we want to be able to set the Excel Destination Plus property called FirstRowHasColumnName using a variable in an SSIS Expression. However, the only properties available to be set like this are StartRow, StartColumn and Worksheet.
In our package, the component named "Excel Destination Plus" only exposes the three default properties that can be set by an SSIS Expression. They are StartRow, StartColumn and Worksheet. In the component named "Excel Destinaton Plus 2", we have modified the .dtsx code behind it to expose the property called "[Excel Destination Plus 2].[FirstRowHasColumnName]" shown below.
You can see that, by modifying the code, the property for FirstRowHasColumnName is now exposed.
Here is how we did it.
1. Right click the .dtsx file and choose "View Code".
2. Change the code as follows and save the file.
From:
<property
id="2516"
name="FirstRowHasColumnName"
dataType="System.Boolean"
description="Specifies first row contains column names.">true</property>
To:
<property
id="2516"
name="FirstRowHasColumnName"
dataType="System.Boolean"
description="Specifies first row contains column names."
expressionType="Notify">true</property>
You may use this process for all of the properties associated with the COZYROC components that are inside your Data Flow.
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 ...Is there a way to set the parameters of a Javascript dynamically when using Javascript Task.
When using JavaScript Task, sometime you create parameters in your JavaScripts, like you see here in the screen capture. You may want to set their values dynamically using variables in the variables window. From the documentation: Under the hood, in ...Salesforce Source: How to modify SOQL Statement property dynamically at runtime from SSIS Expression
The Salesforce SOQL Statement property is available in the data flow properties list to be set dynamically at run time. Note: The process for setting the BatchSize, Object and ObjectFilter properties for Salesforce are the same as for the Statement ...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 ...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 ...