Welcome to EMC Consulting Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server » 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
Powered by Community Server (Personal Edition), by Telligent Systems