Post reply

How to Capture Inner Package Global Variables from remote server package

  • October 29, 2005 at 3:33 pm

    #67008

    I have two servers.  I have a package on Serv1 that loads data to Serv1.  I have a package on Serv2 that will pull that loaded data from Serv1 to Serv2.  To specify the exact rows, i need two global variables defined in the package on Serv1...I need to pass these variables to the package on Serv2.  The execute package task has "inner package global variables" and "Outer package global Variables".  It seems there should be an obvious way of getting the value from the inner to the outer package...but it is eluding me.

    Any help greatly appreciated!

  • October 30, 2005 at 3:37 pm

    #601197

    If I'm reading you right, you want to pass a value back to the calling package ??

    Unfortunately, this is not as obvious as it seems

    One technique I've seen work is to pass the GlobalVariables pointer to the child package. This creates an implicit link so you can update variables in the parent package.

    Check this article which has details about how this si done,

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply