blogs.conchango.com

Browse by Tags

• Dataflow Task
• Foreach Loop
• Nugget
• SQL Server
• SQL Server Integration Services

• SSIS and embedded SQL

  I have been having an email back-and-forth with Jon Jaques which began with us discussing various limitations regarding BLOB support within the OLE DB Command and ended with Jon’s blog entry SSIS and the Perils of Embedded SQL where he discusses the drawbacks Read More... Posted 17 October 2008 10:13 by jamie.thomson | 8 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Dataflow Task, Execute SQL Task

• 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