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