SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm developing a SSIS package, I've an ADO .Net destination, my input is a XML file, I wish insert a fixed value into one of the output column, the fixed value is stored into a package variable, is it possible?
Definitely, it is possible.
You just need to use SSIS Derived Column Transformation.
It will allow you to add a new column with the value from the SSIS variable.
Check it out here: warning-about-using-string-variables-in-derived-column-expressions
Hi @Andrea Caldarone ,
Please refer to the following pictures: