This seems to be a pretty hot topic so I guess I'll ad my post.
We have SQL 2000 as a cluster on 2 servers.
Our DTS package brings a small amount of data into some tables into another
database and then runs a visual basic executable which validates the data,
then pushes it back into the production database.
2 of the cluster instances are identical: one is for test, one is for
Here is what is happening:
In the test instance the DTS package runs fast, both when executed directly
and when scheduled as a job (about 30 seconds).
In the production instance the DTS package runs fast when executed directly
(about 30 seconds) but when scheduled it takes about an hour and a half!
This makes no sense to me.
I checked to make sure that the user who owns the DTS package and the
scheduled job has permissions (they do - they are a sysadmin) AND that they
have the correct registry access permissions using DCOMCNFG- they do.