Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-08-30 : 15:43:07
|
| Hello everyone,I need to geenrate a list of SSIS package names matched with the Job Name(s) that executes that package.The sysdtspackages90 table contains the package name in the "name" column. And the job name of course is in table sysjobs. Table sysjobsteps has column "command" which contains the package name but it is embedded along with other data so I cannot easily extract just the package name.Has anyone found a way of listing all the Package Names along with their corresponding Job Names?Thanks for any ideas! John |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-08-30 : 16:16:41
|
try a join via sysjobsteps.command like '%'+sysdtspackages90.name+'%'
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
How to Cross-Ref Job Name to SSIS Package Name