Welcome to EMC Consulting Blogs

Browse by Tags

• Execute SQL Task
• Expressions
• raw files
• SQL Server Integration Services
• SSIS

• SSIS Nugget: Setting expressions

  Whilst reading posts on the SSIS forum of late it has become evident that people are unaware of the power that expressions can provide within an SSIS package. This is understandable - alot of people are starting to use SSIS now but expressions aren't Read More... Posted 11 March 2006 09:24 by jamie.thomson | 30 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Expressions, Foreach Loop, Nugget

• SSIS Nugget: Execute SQL Task into an object variable - Shred it with a Foreach loop

  Here is the first in what will hopefully be a long series of postings in what I have colloquially called my SSIS Nuggets series. I was reading a post this morning from Sam Bendayan in which he was pondering how to store a full result set returned from Read More... Posted 04 July 2005 09:55 by jamie.thomson | 43 Comments Filed under: SQL Server Integration Services, SSIS, Execute SQL Task, Foreach Loop, Nugget