DTS package

Question

Post reply

DTS package

shanila_minnu

Hall of Fame

Points: 3465
More actions
May 28, 2009 at 3:37 am

#138168

Hi experts,
is there any query to find out the DTS names used in a server.
like (select * from sysjobs) for jobs

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

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

Tom257 SSChampion Points: 11543 More actions · Answer 1

Check out tables in msdb such as [dbo].[sysdtspackages] - there are a few others with similar names too.

Pradyothana Shastry SSCertifiable Points: 5211 More actions · Answer 2

Use msdb

go

select * from sysdtspackages

- Pradyothana http://www.msqlserver.com

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Pradyothana Shastry (5/28/2009)
Use msdb
go
select * from sysdtspackages

Why do you keep on repeating what other people post?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

tosscrosby SSCoach Points: 18045 More actions · Answer 4

Does wonders for the post count.......

-- You can't be late until you show up.

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 5

GilaMonster (5/28/2009)
Pradyothana Shastry (5/28/2009)
Use msdb
go
select * from sysdtspackages
Why do you keep on repeating what other people post?

Agreed, I can understand if the posts were a few minutes apart, maybe two people responding at the same time and one forgot to refresh his/her screen. But three hours later?

Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein