Browse by Tags

• sql server integration services
• ssis
• t-sql
• xquery

• 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 Read More... Posted Saturday, November 7, 2009 2:58 AM by jamiet | 16 Comments Filed under: nugget, sql server integration services, ssis, SSISPackageStatsCollector, t-sql, XML, XPath, xquery

• 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 Read More... Posted Sunday, October 18, 2009 11:08 PM by jamiet | 55 Comments Filed under: nugget, sql server integration services, ssis, SSISPackageStatsCollector, t-sql, XML, XPath, xquery