July 2, 2007 at 9:59 am
Hello,
Is there a table in the MSDB database that would reveal DTS packages where a given package would fire one or more other packages?
In our environment, when a package fires another package, it does so by implementing the ‘Execute Package’ task in DTS. In the package properties, the naming convention used to describe such a task would look like this; DTSTask_DTSExecutePackageTask_1.
July 2, 2007 at 1:11 pm
If the step names still match the task names, you can query sysdtssteplog looking for stepname like '%DTSExecutePackageTask%'. This only works for packages that have been run.
You might also try saving all the packages to VB files and editing them to search for the Execute Package task. I think I've seen something in the script section of SqlServerCentral that will script all the packages out.
Greg
Greg
July 2, 2007 at 1:26 pm
Thank you for your help!
CSDunn
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply