Hi,

Last week I began to use a new computer with Windows XP pro. Now I cannot
use the SQL2K's EM to open DTS packages. I tried SP3 and later SP4 but it
always says "Error occurred during creation of a DTS package". I know the ADO
version is 2.8.

Would you share your solution for this issue?

Thanks in advance.
James

Hello James,

When do you get this error?

What are you doing at the time of the error?

Maybe you could try reregistering the DTS dlls and try again

http://www.sqldts.com/default.aspx?225

Allan

Thanks for your quick reply.

Now I couldn't register dtspkg.dll and dtspump.dll. The error code is
0x80020009. Following link is promising BUT I simply felt too nervous to try
the approach for fear that can cause other odds.

http://www.alegsa.com.ar/N/i61/Dllre...%20a%20dll.php

Hope someone here actually solved this before and shed on me your great light.

"Allan Mitchell" wrote:

Actually, that fix in the article does work in a lot of
cases.
This is a good thread on the error:
http://groups.google.com/group/micro...f3909ee?hl=en&
It also discusses changing the registry permissions on the
key and subkeys for HKEY_CLASSES_ROOT\TypeLib.

-Sue

On Mon, 16 Jan 2006 14:45:02 -0800, "James Ma"
<JamesMa (AT) discussions (DOT) microsoft.com> wrote:

Thanks a lot. I did those tricks and it works now.

Thanks again.
James

"Sue Hoegemeier" wrote: