CODEWITHSUNDEEP
ssis
user1348424
user1348424

Reputation: 839

How to get input dataset from Look up transformation in ssis

i have an flat file input dataset, and i need to use look up transformation for comparing 3 columns with that of input to reference dataset used in look up transformation.

After look up operation operation is performed i need to get the input columns also along with reference dataset columns.

I googled but i coluldn't find any method to get input dataset from look up. The only solution left is Merge join. I dont want to use merge Join

Upvotes: 0

Views: 273

Answers (1)

grapefruitmoon
grapefruitmoon

Reputation: 3008

The input columns are automatically added to the output pipelines of a Lookup transformation. You'll be able to reference them in subsequent transformations.

Upvotes: 1

Related Questions