In this article, we are going to explain to you the Case Sensitivity problems that occur while working with SSIS Lookup Transformation with an example. In this example, we are going to use the OLE DB Connection to connect with SQL Server. Before you start creating your SSIS lookup case sensitivity package, Let us see the Lookup … Read more
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
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
