How to pass variables defined in SSIS as parameters to SSIS Process task that runs a bat file. In the bat file the user name and password would be replaced with %1 argument and input will be passed from the script task that will receive input from a . NET front-end.
Just add a script component , add an output column of type DT_I8 (assuming it's name is OutColumn ) and mark NAME1 column as Input. Great answer. Thanks!
I am using Execute Process task in SSIS 2008 R2. I have a variable idVar
which is of data type Int32. I need to pass this variable to property Arguments
of the task so the process executable can take this variable as argument. I use expression to assign @idVar
to Arguments
.
Now the system says I need to convert Int to String so I used the following expression in the expression builder
(DT_STR, 10, 1252) @[User::IdVar]
It gives the following error:
Expression cannot be evaluated.
Additional information:
The expression "(DT_STR, 10, 1252) @[User:IdVar]" has a result type of "DT_STR",
which cannot be converted to a supported type.
(Microsoft.DataTransformationServices.Controls)
What is the correct way to type cast the number to string?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With