Look Up In Ssis. In sql server integration services (ssis), the lookup transformation is used to perform look up values in a reference dataset. By default, lookup in ssis uses the ole db connection manager to connect with the.

Please use the following query. Our transform package will convert the data and output it to the target system. Select no cache mode ,connection type is ole db connection and redirect rows to no match output.