Hi All,

I am using SQL Server 2000 - DTS.

I have multiple database connection & datapumps - running in parrallel.
All uses same Global variable, which is being iniaitized in an ActiveX Script.
I have tried playing around changing Relative priority of this step (tried
putting highest & lowest number - not sure how it works here).

But still there are few datapump steps which starts executing before ActiceX
script.
Resulting in errors as -
"Step 'DTSStep_DTSDataPumpTask_11' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:No value given for one or more required parameters.
Step Error code: 80040E10"

How do I make sure that those steps never get executed before ActiveX script?

I had simlar issues in past, but playing around the tranformation had fixed
it (like executing the ActiveX package, refresh, save).

Any help will be appreciated.

Thanks,
Kedar