March 14, 2006 at 9:15 am
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
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
That's great, thanks.
Wouldn't call the VBS interesting, though!
March 14, 2006 at 9:45 am
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
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