• 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.