Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Browse by Tags

All Tags » SQL Server Inte... » Execute SQL Task

  • Making the case for expressions instead of parameterised SQL (and vice versa) : SSIS Nugget

    [Although I colloquially refer to myself on this blog as “SSIS Junkie” it won’t have escaped the notice of regular readers that I haven’t been talking about SSIS much lately, in fact nothing of real substance in regard to SSIS has appeared here since Nesting variables to calculate values on 24th October. The reason for that is that I simply ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on December 8, 2008

  • 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 of the Execute SQL Task – namely that the Execute SQL Task has no understanding of the ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on October 17, 2008

  • 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 the Execute SQL Task. He had followed BOL (which according to Sam states that a Full Result Set ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on July 4, 2005
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems