DTS Global Variables Headache

Hi there,

I've writeen a DTS Package that gets an XML document from a website and then stores it into a global variable.

I've also written a stored procedure which calss and executes the DTS and then stores the dts global variable into a variable in the stored proc.

However, I'm experiencing a bit of a problem. My code doesn't seem to run the dts. It will get the DTS variable OK, but doesn't seem to actually run the DTS...

each time the dts is run MANUALLY, the global variable is changed (this is due to the xml doc generating different data all the time) However, when you access this variable from the stored proc, the value never changes.

I've attached my stored proc code and would appreciate any help or pointers in the right direction