Cache Transformation and Look UP transformation with Default Buffer Max Row

Cache Transformation and Look UP transformation with Default Buffer Max Row

Solution: Avoiding the data checking between SQL Server and SSIS Engine done by Look UP process while comparing the data for Insert and Update. Data are moved to Cache or Memory with 3 Options as Full or Partial or None where Full defines entire table data and the required columns are taken into Memory. For Partial only a percentage of data are taken to Memory.



Step 1: drag and drop 2 Data flow transformation and Name it as DFT Cache & DFT Lookup

Step 2: drag and drop the OLEDB Source into DFT Cache and create Connection Manager.