lookup transformation in ssis Archives

SSIS Lookup Transformation in Full Cache Mode

In this article, we will explain how to perform SSIS Lookup Transformation in Full Cache Mode with an example. To use Full cache mode, we must use the Cache Connection Manager and SSIS Lookup Transformation. Before you start creating your SSIS Lookup Transformation in the Full Cache Mode package, Please refer to the Lookup article … Read more

Lookup Transformation in SSIS

The Lookup in SSIS is one of the most useful transformations, which is used to compare the source data to the existing data from the reference table (or Lookup Table) and find matching ones. This SSIS transformation allows you to perform data lookups. For the non-matching rows, we can further do some more work. Case … Read more