March 18, 2004 at 8:48 am
In a parent package, I am stepping though a table which contains names which I can use to identify which child package I want to run.
I am storing these names in a global variable and then using a dynamic properties task to change the package name. The Parent task is failing because the Child Package ID does not match.
I really don't want to store the package ID as well. Is there a way round this problem?
March 19, 2004 at 10:37 am
No responses so seems this not possible. I will try a different way.
March 19, 2004 at 4:07 pm
I haven't tried using a GV for pkg name, but this should do what you want.
(In ActiveX task):
...
SET oPkg = CreateObject("DTS.Package")
' get child pkg.
' "256" is Windows Authentication flag.
' See BOL re: LoadFromSQLServer for further details
oPkg.LoadFromSQLServer "ServerName\Instance", "", "", "256", _
, , ,"PackageName" 'Substitute GV for pkgname?
'pass a GV into child pkg
oPkg.GLOBALVARIABLES.item("gvSSN").value=rs.Fields("ssn")
' run pkg
oPkg.Execute
oPkg.Uninitialize()
Set oPkg=Nothing
March 22, 2004 at 5:17 am
Bill, that's exactly what I wanted to do. Many thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply