Hi!

I have a dts package that sends data to about 30 different external
databases. This has ran just fine, but suddenly I get a problem with
connections to a few of them.

I have an active x script that changes the target connection each time
the package is run based on some global variables.

What puzzles me is that running the dts package in the dts designer
works just fine. But I am not able to run the package with DTSrun from
query analyzer that is inside a stored procedure. Then it fails on the
first step that does anything on the target database.

Anyone have any suggestions about what might have happened?

(SQL Server 2000)