Post reply

DTS package in MSDB

  • March 14, 2006 at 9:15 am

    #67239

    Out of interest, and sorry if this has come up before, but does anyone know how a DTS package is stored in msdb?

    I've had a rummage around the systems tables to no avail.

    Presumably it would be some nasty indecipherable code?  Just curious.

    Thanks

  • March 14, 2006 at 9:25 am

    #626576

    I'm fairly sure its in dtspackages in msdb.  The "guts" of the package are probably in the packagedata column, which is an image datatype.

    Looks like "nasty indecipherable code" to me.

    Did you know you can store a package either as a structured storage file (also something nasty and indecipherable, I'd bet) or as a VB program (which is actually readable and interesting)?

    Using the 'save as' dialog from the package designer, just change the "location" to "Visual Basic File" and then you see an option for where to store the file.

    HTH.

  • March 14, 2006 at 9:36 am

    #626578

    That's great, thanks.

    Wouldn't call the VBS interesting, though! 

  • March 14, 2006 at 9:45 am

    #626584

    I think it is in sysdtspackages.  Also try

    SELECT *

    FROM msdb..sysobjects

    WHERE Name like '%dts%'

      AND xtype in ('u', 's')

    This site has excellent DTS documentation.  http://www.sqldts.com/default.aspx?204.

    Good luck.

     

    - Paul

    http://paulpaivasql.blogspot.com/

  • March 14, 2006 at 9:50 am

    #626587

    Yep thanks for this, alas all appears undecipherable.

     

    will try that other site you mentioned.

     

    cheers

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply