Browse by Tags

• Datadude
• nugget
• Powershell
• sql server integration services
• ssis
• SSISPackageStatsCollector
• t-sql
• video
• Visual Studio
• XMLPad
• XPath
• xquery

• XMLPad – a new tool in my developer utility belt

  Yesterday I was on the lookout for a free tool that would help me write XPath statements. I put a shout out on Twitter and Johan Barnard replied saying : Give XMLPad a try http://www.wmhelp.com/xmlpad3.htm I’m sure there are legions of developers out Read More... Posted Friday, February 11, 2011 8:22 PM by jamiet | 2 Comments Filed under: XML, XMLPad, XPath

• Querying Visual Studio project files using T-SQL and Powershell

  Earlier today I had a need to get some information out of a Visual Studio project file and in this blog post I’m going to share a couple of ways of going about that because I’m pretty sure I won’t be the only person that ever wants to do this. The specific Read More... Posted Monday, January 17, 2011 10:11 PM by jamiet | 3 Comments Filed under: Datadude, Powershell, t-sql, Visual Studio, XML

• 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. Read More... Posted Saturday, February 27, 2010 5:53 PM by jamiet | 8 Comments Filed under: nugget, sql server integration services, ssis, video, XML

• 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