ADO .Net Destination map a column to a variable value

Question

Hello,

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?

Answer 1

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

Answer 2

Hi @Andrea Caldarone ,

Please refer to the following pictures:

1. 
   
2. 
   

Best Regards,
Mona