Post reply

How Do I Access the Variables of a Parent Package in Child

  • November 9, 2006 at 5:50 pm

    #171002

    I am executing a "Child" package [SSIS_Sub1] by executing a "Execute Package Task" in another package [SSIS_Mainline].  I read that I should be able to read the "Package Variables" in the executed package.

    Given that there is a variable with package scope name MainlineVariable (in SSIS_Mainline], can I gain access to it's runtime value from the child process [SSIS_Sub1].

    If yes, where can I find an example??

      Thanks,

              Rick

     

     

  • November 9, 2006 at 6:26 pm

    #670969

    Here's a link that tells you how to do what you are trying to do.  It doesn't contain lots of pretty pictures, but it will definitely help you to get the job done.

    http://msdn2.microsoft.com/en-us/library/ms345179.aspx

     

     

  • November 10, 2006 at 5:51 am

    #671053

    Thanks Kaddie

       I walked through and was able to get this to work.  This will allow me to control connections from the Parent process.

       Thanks!

             Rick

     

  • November 10, 2006 at 7:13 am

    #671078

    HTH

Viewing 4 posts - 1 through 3 (of 3 total)

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