sql2k sp4

Howdy all. All of a sudden, my DTS Package is totally unusable. If I try to
run it or design it, I get "unspecified error". I have verified that there
is no corruption in both MSDB and Master. Ideas?


TIA, ChrisR

yes, something trod on your DTS dlls. reregister them and see if that fixes
the issue

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"ChrisR" <ChrisR (AT) noEmail (DOT) com> wrote

get the same error. Solved it by:

If you use DSN, check if it is defined on the computer where to try to
open/run the dts and not only on the computer you created the dts

if remoting connexion, try logoff (Start > Logoff) then reconnect

try to connect by local.SqlServerManager or remote.SqlServerManager to see
if it change something (DSN case)

Nicolas Guinet

"ChrisR" <ChrisR (AT) noEmail (DOT) com> a écrit dans le message de news:
evL8xYvaGHA.996 (AT) TK2MSFTNGP04 (DOT) phx.gbl...