Welcome to EMC Consulting Blogs

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 a file as a recordset hence something like the following will successfully populate the ...

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 to dynamically build the SQL statement that populates the cache when in 'Full Cache' mode ...

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 (grrr) but there was some good news about the following four ...

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 2004. Its not popular because of the quality of the writing, oh no. Its because of the subject ...