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 JavaScript Task for each parameter, which has a non-default value, there is an automatically created task-scoped variable. This allows you to specify an expression in the Variable Windows in case you need to set this value dynamically.
The values you give to these task-scoped variables will automatically populate the values for the script and there is no need for additional expressions in the tasks properties to be created to set the values.
Please be aware of the following note for non-required parameters in cases when you are not seeing their corresponding task-scoped variables:
The task-scoped variable mentioned above can only be seen after you have provided a non-default value for the parameter within the JavaScript Task editor and when you have place focus on the JavaScript Task during your package development.
Example: variable is not visible
Example: variable is visible
Once the parameter has been given a value, the task-scoped variable will persist whether a value is given or not in the editor.
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
How to configure the Javascript Task or JavaScript Component
COZYROC provides many prewritten JavaScripts that can be used in the JavaScript Task and the JavaScript Component. You can also write your own JavaScripts from scratch using the JavaScript Task and JavaScript Component. To locate and use the ...While dynamically changing a connection using variables and expressions inside a Foreach Loop, my source component doesn’t return any data.
Action: While dynamically changing a connection using variables and expressions inside a Foreach Loop, my source component doesn’t return any data. Solution: Be sure to set RetainSameConnection=False in your connection. Ideas: For scalability and ...How to dynamically set a user parameter in a REST Connection.
Create a REST Connection with a custom configuration to use for our example. Let’s start by creating a REST Connection configuration that has authentication with two user parameters. We will set their values dynamically from variables using an ...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 ...Where can I find the documentation for the JavaScript Task?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the JavaScript Task can be found at the following link. For many of the components you can find resources ...