Tag Archives: lookup

SSIS Lookup Cache Connection Manager with Excel

The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of the limitations of the lookup is the fact it requires an OLEDB connection. However, with the cache connection manager you … Continue reading

Posted in SSIS, Syndication | Tagged , , | 1 Comment

Partial Cache Lookup with a Date Range

When setting up a lookup in SSIS it is usually just a basic comparison between two key fields like an ID field. What if you want to compare and id and also find the specific date range. Let’s say the … Continue reading

Posted in SSIS, Syndication | Tagged , | 1 Comment