THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » sql server inte... » For Each Loop   (RSS)
  • Looping over SQL scripts and executing them : SSIS video nugget

    Earlier today while surfing the SSIS forum on MSDN I noticed a question that asked how one could execute a series of .sql files using SSIS. One suggested approach was to read the contents of the file(s) into a variable using a Script Task and then execute the contents of that variable using an Execute SQL Task. Well, that would work but there is ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 24, 2010
Privacy Statement