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 » XPath » xquery   (RSS)
  • 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
  • XML Optimization Presentation Sample Code

    During the XML Optimization presentation today I'll refer back to the sample code posted at  I'll also update this post with additional sample code by tomorrow. UPDATE: The PowerPoint presentation and sample code are attached to this post in the ZIP file. Jacob Sebastian's book ''The Art of ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on May 16, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement