Lookup in SSIS

SSIS Lookup Transformation Using OLE DB Connection Manager 6

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. For the non-matching rows, we can further do some more work. Case Sensitivity in Lookup Transformation: Lookup in SSIS is Case-Sensitive, Kana-sensitive, Accent-Sensitive. Lookup … Read more

Lookup Transformation in SSIS

SSIS Lookup Transformation Using OLE DB Connection Manager 11

In this article, we are going to explain how to perform Lookup Transformation in SSIS using OLE DB Connection Manager with an example. In this example, we are going to use the OLE-DB Connection to connect with SQL Server and perform SSIS lookup operation. TIP: Please refer the Lookup in SSIS article to understand the … Read more