Re: Passing Global Variable

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello kvangor27@xxxxxxxxx,

try setting everything to execute on the main package thread.


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

Hi,

I have a DTS package setup to load a forecast from an Excel file. We
have 17 different countries to load, so instead of having a DTS
package for each country I'd like to use the same one for all. I
setup a package to call the forecast load package, and I'm passing a
global variable with the file path of the Excel file. I'm using the
Dynamic Properties task to change the Excel file connection to
whatever country is being loaded in the forecast load package.

I'm getting a "execution canceled by user" error when executing the
Execute package task. I have defined the global variable to be passed
with the Inner Package Global Variables tab, but the child package
does not seem to be picking up the variable. Am I missing
something????

Also, if I set the Global Variable within the child package and just
execute the package directly it works fine.

Thanks in advance for any assistance!

Kevin



.

Quantcast