question

Mason Ghafoori avatar image
Mason Ghafoori asked

SSIS - using variable to input into a column when loading flat file

I am using a flat file to read the data and load into SQL Server. How can I populate one of the fields on the table with a variable that is available in the package but not in the flat file. I am trying to load File_Id into the table.

ssisvariable
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tom Staab avatar image
Tom Staab answered

Assuming you are already using a data flow to import the flat file, just insert a Derived Column task between your source and destination. Then add the variable as a new derived column.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.