I have to check for deleted records in the Vendor table.
Therefore my SQL table has the records that may be deleted, and my Vendor using ODBC is missing the records. Therefore the driving table is my OleDB, my lookup needs to be the ODBC. But when I do the lookup it only offers the connection Mgr for the OleDB and it titled OleDB connection Mgr..
I originally was doing this piece successfully in a SQL Stored Procedure using a linked server. The SSIS package will execute it. I wanted to change it to challege myself to learn the SSIS skills.. I fear I tend to lean on my strong skills which is hindering me in developing my newer skills. But in this case, Is the SQL Stored Procedure really the only way I can do this?