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

DTS system information Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2007 7:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, September 25, 2007 8:07 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:31 PM
Points: 32,780, Visits: 14,941
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
Posted Tuesday, September 25, 2007 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, October 02, 2007 9:16 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 4,056, Visits: 5,182
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
Posted Thursday, June 10, 2010 9:26 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Monday, February 17, 2014 2:51 PM
Points: 418, Visits: 107
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 »

Add to briefcase

Permissions Expand / Collapse