Michael Entin's notebook

Michael Entin's notebook

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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.
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (4 items)