DTS system information

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » DTS system information

DTS system information

Rate Topic

Display Mode

Topic Options

Author

Message

george.eckenrode

Posted Tuesday, September 25, 2007 7:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 19, 2007 1:55 PM
Points: 2, Visits: 11

I am looking for a system table that has information per DTS package like what is stored for Jobs in the msdb.dbo.jobs table. Anyone ?

Post #402558

Steve Jones - SSC Editor

Posted Tuesday, September 25, 2007 8:07 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

What information are you looking for? I'm not sure what you mean like what is in jobs".

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #402579

george.eckenrode

Posted Tuesday, September 25, 2007 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 19, 2007 1:55 PM
Points: 2, Visits: 11

What I am looking for is a way to tie the DTS package to it's related JOB. If I was to do a SELECT * FROM msdb.dbo.sysjobs I get a lot of information about the JOBS. If I do a SELECT * FROM msdb.dbo.sysdtspackages I get a lot of info about the DTS Package. But, so far, the only tie between the two is if I turn Logging on within the DTS package . . . but, I still cannot tie DTS to JOBS once scheduled. There is a rare Description and the use of Script To SQL to find, but, many times the DTS package looses the description and picks up something else and the GUID is sent to the JOBS. I am looking to tie the DTS to the JOBs running to perform a one to one or one to many to maintain what is there and what does not need to be there etc.

Post #402626

Greg Charles

Posted Tuesday, October 02, 2007 9:16 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:50 PM
Points: 4,006, Visits: 4,847

The only link between jobs and packages that I can think of would be in sysjobsteps where the DTSRUN command is stored in the command column.

Greg

Greg

Post #405713

nhamilton

Posted Thursday, June 10, 2010 9:26 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, October 22, 2012 11:21 PM
Points: 418, Visits: 100

You will only be able to see name of the package in the dtsrun commands, for job steps if they were created unencrypted.
If you see something like DTSRun /~Z0xAEB6B4553DB09E5771B56FD6C06B30B37....... Then the job was created referencing a specific version of the package and the command is encrypted. What you are looking for is something like: DTSRUN /SServerName /E /NPackageName

Post #935442

« Prev Topic | Next Topic »

Permissions