On Enterprise Manager have created two DTS packages:
1 = Transfer Data
2 = Process Cube
In total we have loads of these.
What I want to do is to create a DTS that will run the toehr 2 DTS in sucessions.
Now when I use the Execute Package Task facility to run the 2 DTS, it fails...or just hangs for an eternity.
Is there way to run (say) 7 Execute Package Tasks without the master DTS failing?Any help please.... searched the web with no valid answers to this issues
