August 28, 2007 at 7:43 am
Hi,
SQL Server 2000 Developer Edition.
The problem, at DTS startup, it creates an err
msg: "Error in DLL", I did some research, tried
[Regsvr32 "C:\Program Files\Microsoft SQL
Server\{sqlversion}\Tools\Binn\dtspkg.dll"]
to register the dtspackage dll, it did but to no
avail.
the DTS Wizard would continue, however, it won't
proceed after selecting a Source datasource.
FYI, I've downloaded and applied Service Pack 3 for MS
SQL Server 2000.
I was thinking about a)back up all dbs; b) removing
all sql server instances; c) do a fresh restallation.
Not too sure though.
Please advise. Many thanks.
August 28, 2007 at 8:17 am
What DLL does is state is the error. I have seen this before when I reimaged my machine and opened a package with an Oracle connection in it. The issue was because I didn't have the Oracle drivers reinstalled at that point so the package could not find the DLL's it need with regards to the Oracle connection.
Exactly what throws the message, opening the package or a particular component?
August 28, 2007 at 8:46 am
Sorry, wasn't clear enough, "cocreateinstance error in DLL DTS Wizard" when launching the DTS wizard. Just resolved it by registering oledb32.dll by hand. Funny thing is, when I searched googling and searched again comp.database.ms-sqlserver NG yesterday, they did not bring up this solution though it was available.
August 28, 2007 at 8:58 am
That is life as it seems. Glad you found your answer thou.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply