how to find out dts package owner

Question

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

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

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 1

SELECT * FROM msdb.dbo.sysdtspackages

Field is owner..

CEWII

charipg SSCrazy Eights Points: 9888 More actions · Answer 2

SSCrazy Eights

Points: 9888

September 17, 2009 at 5:17 pm

thanks..........

KumarVelayutham SSCrazy Points: 2204 More actions · Answer 3

How to view dtspackage error log in a table?

select * from msdb..sysdtssteplog order by endtime desc

select * from msdb..sysdtstasklog order by endtime desc

select * from msdb..sysdtspackagelog order by logdate desc

How to find dtspackage owner name ?

select * from msdb..sysdtspackages where name ='dtspackagename'

Hope above query will help.

Kumar

http:\\sqldbataskwithkumar.blogspot.com

Regards,
Kumar

Elliott Whitlow SSC Guru Points: 102296 More actions · Answer 4

Not to put too fine a point on it, but this thread is nearly 2 years old..

CEWII