Saturday, September 26, 2015

How to use a Cache Transform with Excel/CSV Source File

In order to compare the data from 2 excel files a lookup transformation is used.Add a data flow task with excel source.



Configure the Cache Transform for an excel source.



Set the index position of the source column which would be looked up  to 1.

Configure the column mappings of the source excel file and the cache


The Cache Connection Manager is configured to be used in the lookup transformation.Same procedure would be followed for a csv source file.
Posted by at

1 comment:

  1. James ZicrovAugust 22, 2020 at 3:20 AM

    I feel there is a need to look for more and more aspects of SQL and SSIS tools.There is a greater need in order to break down complex IT problems and solutions.

    SSIS Upsert

    ReplyDelete

Subscribe to: Post Comments (Atom)