I set up the following items listed below. I am trying to pass CurBranch
from the outer to the inner package but cannot seem to make the connection.
How can CurBranch be connected to vartest ?

The Outer Package package contains two tasks:

SQL Task: Select CurBranch As CurBranch From TmpSRBst010
Input Parameter: None
Output Parameter: CurBranch (Rowvalue)

Package Task:Inner Package Global Variables: vartest1
Outer Package Global Variables: CurBranch

The Inner Package contains the following task:

SQL Task: Update Rmtest2 Set RptDir = ?

Input Parameters: vartest1
Output Parameters: None

- create a gv called vartest1 in your child package
- remove the inner package gv for your package task

Make sure the select-statement for CurBranch returns only 1 row/value.

See also this thread:
http://www.microsoft.com/technet/com...9-8c72fb339174

sorry, to quick with posting. vartest1 = CurBranch. so like this:

The Outer Package package contains two tasks:

SQL Task: Select CurBranch As CurBranch From TmpSRBst010
Input Parameter: None
Output Parameter: CurBranch (Rowvalue)

Package Task:Inner Package Global Variables: None
Outer Package Global Variables: CurBranch

The Inner Package contains the following task:

Create a gv called CurBranch (just to be sure. also enable "explicit
global variables"

SQL Task: Update Rmtest2 Set RptDir = ?

Input Parameters: CurBranch
Output Parameters: None

Hello rmcompute,

I would be tempted to call the inner package through the DTS object model
in an active Script task. This way you have a huge amount of control over
the child package.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com