October 8, 2006 at 1:39 pm
I have a number of DTS packages that I'm looking to merge into one as part of a server consolidation project.
However when I try to drag or copy multiple objects form one DTS package to another it won't allow me. It says I can only copy one object.
Is it possible to copy or merge them somehow?
This last thing I want to do is have to recreate everything!
October 9, 2006 at 11:10 am
Would an Execute Package Task help? It is in the 3rd row, 2nd column of the Task Toolbox in the SQL2K DTS Designer. You may have to assign Global Variables to the child package. Another method can be found in http://www.sqldts.com/default.aspx?215
October 9, 2006 at 11:20 am
no not really as this just puts the call in to another package which is being done anyway only from the controlling application.
At present a VB app is calling the packages in tern so this just moves that to the server but doesn't reakly consolidate them.
The desitnation connections can't be mapped this way.
I'm considering porting the entire thing to SQL 2K5 and putting it into a VB.net app/service instead but not sure what this entails.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply