Use Flat File Data in Lookup Transformation in SSIS Package ( Cache Transformation) - SQL Server Integration Services (SSIS) Tutorial


Let's say we get our reference data in a flat file and before we load data from source to destination we have to match with our reference data. If data matches we will load otherwise ignore the non matching source data.

What we will learn in this video

  1. How to read data from Flat File Source and Load into Memory by using Cache Transformation
  2. How to  use Cache Transformation Connection Manager in Lookup Transformation
  3. How to Read Source Data from SQL Table and Compare by using lookup Transformation and load only matching records to destination in SSIS Package
  4. How to use OLE DB Destination in SSIS Package