Could not create an instance of the DTS package

[nenita]

Here is a problem regarding using the DTS in SQL Server 7.0 to importing data from Access97.
When I tried to use the Data Transformation Services (DTS) in SQL Server 7.0 to import data from Access yesterday, it gave me this error message when I clicked the finish button.

"Could not create an instance of the DTS package"

So, I search for Microsoft Knowledge Base and found this:

http://support.microsoft.com/support/tshoot/sql7dts.asp

I have followed the steps mentioned in the knowledge base.
When I came to the step:
Unregister and register the following DTS DLLs:
1. Dtspkg.dll
2. Dtspump.dll
3. Dtsui.dll
4. Dtswiz.dll

There was an error message for unregister and register Dtswiz.dll. (I can unregister and register successfully for the other three dlls.)
Here is the error message:

"Dtswuz.dll was loaded, but the DllUnregisterServer entry point was not found.
DllUnregisterServer may not be exported, or a corrupt version of Dtswiz.all may be in memory.
Consider using PView to detect and remove it."

I have already stopped all the SQLSever services, but it still doesn't work.

So, I tried the DTS anyway, but it still give me the first error message I mentioned above.

Can you tell me how to overcome this?

The SQLServer is located in WindowsNT4 with Service Pack 5.

Thanks.

 

[rajeevnandanmishra]

Hi Nenita,
Just give a try.
In the services set the SQL server and executive services as Manual (i.e. if they are market as automatic, change it to manual). Shutdown the system and restart it. Now try to unregister the required DLL.