Troubleshooting SSIS Cache Connection Manager Lookups

The SSIS Cache Connection Manager was introduced as a means of performing a lookup against a non OLEDB data source.   Once inside the Data Flow, under Data Flow Transformations within the toolbox, you will see a Cache Transform. Mike Davis walks through a good example of how to create and use a Cache Connection Manager […]