Lookup multiple rows?

Can SSIS Lookup do what this user wants it to do? I have a problem with a lookup output, I get this warning: The Lookup transformation encountered duplicate reference key values when caching reference data. I know what it is, but I don’t like to avoid this warning, I’d like to get all the rows…


SQL 2008 November CTP is available

Get it from https://connect.microsoft.com/SQLServer One of the improvements in this build is the ability to persist Lookup reference data and use non-OLEDB sources for Lookup.

SSIS Lookups modes or leaky abstractions

I’ve got a question about SSIS Lookup, how-to change Partial or No_Cache mode in Lookup task ? I could give a quick answer, but wanted to explain what I think we did wrong in SQL 2005, and how are we planning to fix this. Before continuing, I recommend everyone to read this article: Joel Spolsky, The Law of…


SqlPerf blog on SSIS performance

Runying Mao and Len Wyatt did a great study of SSIS performance, and posted some results: Getting Optimal Performance with Integration Services Lookups http://blogs.msdn.com/sqlperf/archive/2007/04/24/getting-optimal-performance-with-integration-services-lookups.aspx OLEDB Source with Views  http://blogs.msdn.com/sqlperf/archive/2007/04/29/set-up-ole-db-source-to-read-from-view-efficiently.aspx BLOB and buffer temporary storage http://blogs.msdn.com/sqlperf/archive/2007/05/01/set-blobtempstoragepath-and-buffertempstoragepath-to-fast-drives.aspx  SSIS Performance Counters http://blogs.msdn.com/sqlperf/archive/2007/05/01/something-about-ssis-performance-counters.aspx Buffer size adjustments http://blogs.msdn.com/sqlperf/archive/2007/05/11/adjust-buffer-size-in-ssis-data-flow-task.aspx Parallel execution http://blogs.msdn.com/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx