May 17, 2005 at 10:08 am
I apologize if a put my question in an inadequate forum.
I am having this problem, when I try to do an Import and Export data, from a database I receive this error:
Could not create an instance of the DTS Package
I didn't have this problem until I uninstall the SQL Server 2000 from my computer to install MSDE2000, then I install again SQL Server 2000 and here I detected the error, so I uninstall everything and the error still appear.
I instaledl SP3a and SP4 and the error is still there, I had install and uninstall the SQL Server 2000 so many times that at this point I don't have a clue about what else can I do.
Thanks for your time, (I hope you undestand my English)
May 17, 2005 at 11:08 am
Did you remove MSDE2000 ?
I suspect that MSDE caused problems with the DTS dlls. You could look for the dll called Comcat.dll which should be in the WINNT/SYSTEM32 directory. Mine is version 5.0.2600.1 . If it isn't at least 4.77 then recopy this dll from the SQL 2000 CD and reregister it. You may need to reresister the other DTS related dlls. Although if you haven't removed MSDE200 first , you may want to try removing this, removing SQL Server 2000 and reinstalling it. If you have done this just try reregistering the following dlls:
Re-register comcat.dll [Regsvr32 \winnt\system32\comcat.dll]
you may need to Re-register these DTS DLLs
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsffile.dll
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspump.dll
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsui.dll
Your english is fine!
Francis
May 17, 2005 at 1:38 pm
Did you remove MSDE2000 ? Yes I did.
I follow your directions.
I have a c:\winnt\system32\comcat.dll that have this date 6/19/2003 1:05 PM, I don't know if this is a right file.
Well then when I Re-register the files, and two of then sent me and error:
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll-> returns:
DllRgisterServer in dtspkg.dll failed
Return code was:0x8002801c
Regsvr32 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspump.dll -> returns:
DllRgisterServer in dtspump.dll failed
Return code was:0x8002801c
I have to replace them?
May 17, 2005 at 1:52 pm
Right click on a dll; choose properties then select version tab to display the version of the dll.
The comcat.dll can be copied from the SQL Server 2000 CD. The other dlls were updated with SP 4, so if you need to recopy and reregister, get the other dlls from the SP4 install directory.
You sound like you're having a bad day. Does your company keep base images of servers that you could just reimage the machine and reinstall SQL Server 2000 cleanly? The other alternative in reinstall Windows then reinstall SQL Server. This takes a while which is why many place just create images of the server once it has been configured. I assume this is a test box which is why you don't seem worried about any databases there were installed.
Francis
May 17, 2005 at 5:25 pm
I was truly convinced that I was reply your last message.
I checked the comcat.dll version and is 5.0.2195.1.
I already checked my installation CD's ( one said Personal Edition the other Enterprise Edition) and the comcat.dll wasn't there. ( I have to unzip some file to find it?)
I have a parther that do the same that I did, install and uninstall MSDE 2000 and SQL Server 2000 several times. Now he only have SQL Server 2000 Personal Edition ( like me)
I copy the dtspkg.dll and dtspump.dll from her computer to mine and it didn't work, the regsvr32 is still sending me the error.
I also copy this files from SP4 and is the same situation.
I am having a hard time here because I am making a new system that will be use in my company, our company is like a walk-mart ( but smaller), I mean is a chain of grocery stores, and I am making the cashier system ( I don't know how to said that, the system that will uses the cashier).
May 18, 2005 at 7:53 am
If there is nothing else on this machine, I would rebuild it at this point. That is reformat the hard drive; reinstall windows and SQL Server. This will take less time than trying to find out why your dlls won't register properly, and you'll get a clean install.
Francis
May 18, 2005 at 12:42 pm
You are right
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply