steve14437
SSC Rookie
Points: 36
More actions
February 12, 2009 at 10:14 am
#72677
I am looking for a way to query all of the DTS packages for a specific database name. I started by looking at the MSDB.dbo.SysDTSPackages table but it doesn't offer what I'm after.
Anybody come across this before?
mazzz
SSCertifiable
Points: 6139
February 12, 2009 at 10:39 am
#943041
Have a look at this article:
http://www.dbazine.com/sql/sql-articles/larsen8
It's not quite what you're after, as it only looks for connection names, but it could point you in the right direction
------------------------------------------------------------------------ Bite-sized fiction (with added teeth) [/url]
February 12, 2009 at 11:55 am
#943082
Thanks! I'm giving it a try.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply