DTS not completing

[Cirrus9]

I have created a DTS package. It uses a local db to execute from and a remote SQL web server configured in enterprise to write to. If I am logged in to both servers (Local & web SQL) then it completes without a hitch.

It seems like it is not logging in to the web SQL properly before attempting to run. How do I automate SQL to check the state of the remote server and login if it is not currently online in enterprise?

Thanks for you help in advance.

 

[Catadmin]

You'll want to double-check this in the DTS forum, but I believe you can set up an .ini file with all your connection info, then use a Dynamic properties task (and an Active X Script task to verify whether or not to run the DP task) to get this done.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"