Daily Archives: September 26, 2011

SSIS Lookup Cache Connection Manager with Excel

Posted on September 26, 2011 by MikeDavisSQL

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