From my SQL EM I am trying to load my DTS packages for
editing..

I get the following 2 errors.

Package Error - HResult of 0x80040005 (-2147221499)
returned. Unexpected error occured.
An error result was returned without an error message.

Then..

The selected package cannot be opened. The DTS Designer
has been closed.

This is only an issue with the client tools on my machine,
(which is Win2000) the DTS package can be opened, edited
and executed on other machines.

I have removed and re-installed the SQL EM Tools and the
SQL Service pack is correct.

Any Ideas.

Any help would be great, this is a very annoying problem.

Many Thanks, Lee

What does the package use in the way of tasks and connections, and
connection divers?
Are these all installed on your machine? For example does it use the OLAP
Processing ask, and do you have the OLAP client and task on your machine?
Does it use the Oracle OLE-DB client, and have you installed this on your
machine?


--
Darren Green
http://www.sqldts.com

"Lee" <lgwalker46 (AT) hotmail (DOT) com> wrote

My Package(s) all use standard SQL Server stuff..

SQL Server connection -> Data Pump -> Output File (csv)

No OLAP, Oracle etc. SO all required drivers etc. all
exist on my machine.

Any other suggestions??

Thnx Lee

I think another install (TBD) has stomped all over my SQL
Server EM install.

I have tried registering the SQL Server dll's as described
in article http://www.sqldts.com/default.aspx?225 but to
no avail.

Unless anyone has any more ideas my next step may be a
machine (W2K) re-install.

Help me please :-<

Lee

I was about to suggest reregistering dtsffile.dll in particular as I
have seen that go walk about before. Assuming that has been done, can
you try and rebuild a similar package on your machine and see if
anything is missing or chokes? Perhaps when you try and add a type of
connection it is broken which may help isolate the problem area.

Failing that I would double check SP levels on the clients, perhaps
compare versions of dtspkg.dll for example, and if all that fails you
could start comparing reg keys, but a reinstall may be quicker.

Darren

In message <436d01c47fa8$857b7370$a601280a (AT) phx (DOT) gbl>, Lee
<lgwalker45 (AT) hotmail (DOT) com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org