how to find out dts package owner

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » how to find out dts package owner

how to find out dts package owner

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Wednesday, September 16, 2009 6:53 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

how to find out dts package owner?

Post #789363

Elliott Whitlow

Posted Wednesday, September 16, 2009 8:09 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

SELECT * FROM msdb.dbo.sysdtspackages

Field is owner..

CEWII

Post #789374

charipg

Posted Thursday, September 17, 2009 5:17 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

thanks..........

Post #790036

KumarSQLDBA

Posted Wednesday, May 11, 2011 8:55 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 29, 2013 4:03 AM
Points: 81, Visits: 824

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
http://www.sqldbatask.blogspot.com/

Post #1107034

Elliott Whitlow

Posted Monday, May 16, 2011 10:50 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

CEWII

Post #1109606

« Prev Topic | Next Topic »

Permissions