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

Scenario:

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


4 comments:

  1. Replies
    1. Great Article Image Processing Projects Deep Learning Projects for Final Year JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training Project Centers in Chennai

      Delete
  2. I think SSIS is actually the best and useful tool to solve complex IT problems.SSIS is the only tool to look forward.

    SSIS Upsert

    ReplyDelete