THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSIS » XML » sql server inte... » nugget   (RSS)
  • Outputting data to an XML file : SSIS video nugget

    The last video nugget that I produced seemed to be fairly well received so I thought I would attempt a few more; and indeed, here is the next one. In this video I demonstrate a simple technique for outputting data to an XML file using SSIS’s Script Task. The video is 8m22s long and is embedded below however I’m aware of some problems that we ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 27, 2010
  • SSIS Package Stats Collector version 2

    A few weeks ago I published a blog entitled Collecting information about your SSIS packages which demonstrated a way that you could use T-SQL and XQuery to derive information about your SSIS packages. Since then I’ve made a few amendments to the script that accompanied that blog post as follows: New columns The collected data now includes the ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 6, 2009
  • Collecting information about your SSIS packages [SSIS Nugget]

    Did you know that is is possible to read the contents of a SSIS package (i.e. a .dtsx file) from within SQL Server Management Studio (SSMS) using T-SQL? For example, take the following T-SQL snippet: select cast(BulkColumn as XML)from openrowset(bulk 'C:\tmp\MyPkg.dtsx', single_blob) as pkgColumn; It uses OPENROWSET ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 18, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement