Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to find out dts package owner Expand / Collapse
Author
Message
Posted Wednesday, September 16, 2009 6:53 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 5:52 AM
Points: 412, Visits: 1,011
how to find out dts package owner?
Post #789363
Posted Wednesday, September 16, 2009 8:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
SELECT * FROM msdb.dbo.sysdtspackages

Field is owner..

CEWII
Post #789374
Posted Thursday, September 17, 2009 5:17 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 5:52 AM
Points: 412, Visits: 1,011
thanks..........
Post #790036
Posted Wednesday, May 11, 2011 8:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:28 AM
Points: 102, Visits: 1,050
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
Post #1107034
Posted Monday, May 16, 2011 10:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 15, 2014 5:11 PM
Points: 6,067, Visits: 5,283
Not to put too fine a point on it, but this thread is nearly 2 years old..

CEWII
Post #1109606
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse