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

Hello kvangor27 (AT) yahoo (DOT) com,

try setting everything to execute on the main package thread.


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