> 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
>