November 18, 2002 at 10:43 am
I have 2 DTS packages that I would like to combine into 1 package. Is there an easy way to cut/paste one package into another? I can only cut/paste 1 object at a time, then I must rebuild the linkages in the final package.
-Dan
-Dan
November 18, 2002 at 11:08 am
I think you can only copy one object at a time and need to rebuild all the links.
November 18, 2002 at 11:12 am
Another way to achieve what you are doing is to create a 3rd DTS package and in the new package create tasks that execute the other two packages.
The task type to execute a DTS Package is "EXECUTE PACKAGE TASK".
Hope this helps.
November 19, 2002 at 3:34 pm
You can call pkg from a main pkg using activeXscrip
Johnny...
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim oPkg
Set oPkg = CreateObject ("DTS.Package")
oPkg.LoadFromSQLServer "sqlServerName", "sa", "pwd", , , , , "Child Pkg"
oPkg.Execute
oPkg.Uninitialize()
Set oPkg = nothing
Main = DTSTaskExecResult_Success
End Function
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply