November 4, 2005 at 12:07 pm
I am working with other programmers to build a complex process in DTS. The other people are taking each piece of the process, developing, and testing their piece in other DTS packages. Once their pieces are done, my job will be to integrate the pieces. We are all working via the DTS Designer interface.
Is there a way to import (via automation if possible) the various separate DTS packages into the master DTS package instead of opening each object in the Designer, pulling out the relative information and recreating that object in the master?
The preference is to not have the master "call" the other packages, but rather, pull everything together into one.
Any suggestions?
November 4, 2005 at 12:46 pm
I've looked and have not found a way to copy from 1 DTS to another. Could have used it a few times.
November 4, 2005 at 1:28 pm
Thanks for trying!
November 7, 2005 at 9:49 am
You can call a package from within a package.
IE - Create a master package that calls the individual packages each in turn.
November 8, 2005 at 7:35 am
I was trying to avoid that because I wasn't sure how to pass variables between packages. Can you pass Global Variables between packages?
How does that work?
November 8, 2005 at 9:29 am
You can pass Global Variables into a DTS package via the dtsrun utility. Please see the below link for the full run down
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_dtsrun_95kp.asp
Hope this is of help
November 8, 2005 at 10:01 am
You can pass the Global Variables into a DTS package via an 'inner package global variable'.
Create an 'Execute package' task and look at then properites. You will see the two tabs named as inner and outer package global variables. You want the INNER. You will be able to dropdown to the variable in the gui.
November 8, 2005 at 12:20 pm
Great! ... I will give it a try! Thanks!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply