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 » t-sql » XML   (RSS)
  • 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 problem I was trying to solve was finding out how many objects in my database project (i.e. ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 17, 2011
  • 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
  • Multiple-Valued Parameters

    So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited list of values and I knew I could use XML to do the same thing, yet I had never compared the two ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on February 12, 2007
  • XML Data Type Methods and SSIS Package Variables

    This is a follow-up to a posting from several months ago (Using XML Data Type Methods to query SSIS Packages). I included a temp table (based on information I found in the Microsoft.SqlServer.Dts.Runtime.VarTypeConvert class's constructor) which gives the conversion of the numeric data type value to the appropriate TypeCode (System.TypeCode). ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on December 18, 2006
  • iPod and iTunes - Parsing the XML Library

    So I was trying to figure out a way to get my iTunes/iPod music library into SQL Server. Unfortunately, the XML in the library is not the easiest with which to work. Here is an abridged version of that XML: <plist version=''1.0''>   <dict>      <key>Major ...
    Posted to Peter DeBetta's SQL Programming Blog (Weblog) by Peter DeBetta on December 5, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement