Browse by Tags

• nugget
• sql server
• sql server integration services
• SSISPackageStatsCollector
• XML
• XPath
• xquery

• The perils of double-dash comments [T-SQL]

  I was checking my Twitter feed on my way in to work this morning and was alerted to an interesting blog post by Valentino Vranken that highlights a problem regarding the OLE DB Source in SSIS. In short, using double-dash comments in SQL statements within Read More... Posted Thursday, December 06, 2012 10:21 AM by jamiet | 17 Comments Filed under: sql server, sql server integration services, ssis, t-sql

• 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 07, 2009 2:58 AM by jamiet | 12 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 | 32 Comments Filed under: nugget, sql server integration services, ssis, SSISPackageStatsCollector, t-sql, XML, XPath, xquery