CODEWITHSUNDEEP
sql-serverssis
user3428422
user3428422

Reputation: 4560

SSIS - use stored variable in final OLE DB Destination step

I don't have much SSIS experience, however, I like to use a variable that gets assigned in the Execute SQL Task step in the ole DB Destination step. I guess a bit like a scalar.

Any pointers would be good. Thanks

Upvotes: 1

Views: 573

Answers (1)

Starship
Starship

Reputation: 181

Using the Derived Column task in your Data Flow you can add in your filename variable as an additional column and then use it to map to your destination.

Upvotes: 3

Related Questions