CODEWITHSUNDEEP
winformsc#-4.0parametersssis
buddy
buddy

Reputation: 428

How to pass a value from C# to SSIS package?

I have this source table 

    Employee(ID, Name)

I have this Destination Table

    EmployeeImported(ID,Name,DesgnationID)

During transformation I want to Insert DesignationID from C#. I add a parameter in dataflowtask. Now I don't know what to write in script task. Kindly guide me.

Upvotes: 0

Views: 76

Answers (1)

Jayvee
Jayvee

Reputation: 10873

you don't need a script component to do that, you can use derived column: enter image description here

you just need to create a column inside the derive column component and assign the parameter to it. Then the new column will be available on the pipeline and you can map it to the destination as any other source field.

Upvotes: 1

Related Questions