ADO .Net Destination map a column to a variable value

Andrea Caldarone 66 Reputation points
2020-12-01T16:19:47.033+00:00

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?

44171-mapping.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Monalv-MSFT 5,891 Reputation points
    2021-01-01T09:41:16.52+00:00

    Hi @Andrea Caldarone ,

    Please refer to the following pictures:

    1. 52706-derivedcolumn1.png
      52659-mapping1.png
    2. 52660-derivedcolumn2.png
      52761-mapping2.png

    Best Regards,
    Mona

    0 comments No comments