Welcome to EMC Consulting Blogs

Browse by Tags

• Dataflow Task
• katmai
• SQL Server
• SQL Server 2005
• sqL server 2008
• SQL Server Integration Services

• SSIS: Populate the Lookup component cache from a flat file

  Its a commonly held belief that the Lookup component cache has to be populated from a relational source. Well, that's true, but there is a pretty handy workaround. SQL Server 2005 introduced the OPENROWSET(BULK) command which can return the contents of Read More... Posted 12 March 2008 04:15 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, lookup

• Katmai: SSIS: Lookup component gets a makeover

  Just like Andrea Merkel , Tottenham Hotspur and Britney Spears' career , the Lookup task in SSIS 2005 is in serious need of a makeover. Whilst it is one of the more useful components in the SSIS toolbox it has a number of shortcomings including: Inability Read More... Posted 16 November 2007 19:49 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, katmai, lookup

• SSIS: Big improvements to Lookup in SQL Server 2008

  I awoke this morning to find my inbox full of automated replies from msftconn@microsoft.com thus indicating that someone on the SSIS team has been busy updating many of my submissions to Connect . Generally it was the usual "Closed, Won't Fix" update Read More... Posted 21 August 2007 20:25 by jamie.thomson | 11 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, sqL server 2008, lookup

• SSIS: Checking if a row exists and if it does, has it changed?

  I've been writing about SSIS for quite some time now and probably one of the more popular articles post I have written is this one: Get all from Table A that isn't in Table B ( http://www.sqlis.com/default.aspx?311 ) which I wrote way back in Read More... Posted 12 September 2006 21:31 by jamie.thomson | 99 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Dataflow Task, lookup Attachment(s): UpdateAndInsert.zip