Here is the error:
TITLE: SQL Server Import and Export Wizard
------------------------------
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
------------------------------
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
The connection type "EXCEL" specified for connection manager "{55E5636D-F2A9-48D6-9723-867C9F241F5B}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({F390DBA3-1B52-43F4-A624-9E71D273B4D7})
I really need to get this data into SQL server... why do I have to go through SQL 2000
Regards,
Error attempting to import from Excel
asbailey
This is happening from the Wizard. It happens even after I shut down the SQL server tools and restart them. It happens as I am creating the package. It is not letting me choose Excel at all with this message.
Thanks in advance ...
Dominic99
Arnar Vilhjálmsson
The follwoing post helped me fix it.
http://forums.microsoft.com/MSDN/ShowPost.aspx PageIndex=4&SiteID=1&PostID=363238&PageID=1
The 2nd page of post has a program for you to create and then run.
Read through the post for the directions. It worked for me.
Mike Hernandez - MSFT
I have not got this fixed yet and no, registering dtsconn.dll did not fix the problem. But it looks like some sort of registration is corrupt.
An interesting observation is that as soon as Excel is selected as a source it crashes.
R
Kevinxox
I get the same error as you. This was working for me, then suddenly it stopped working.
Have you found a resolution for this error
efontana
It looks like the registration of connections got broken during the setup on your mahines.
Could you guys check if dtsconn.dll is in your %ProgramFiles%\Microsoft SQL Server\90\DTS\Binn folder
If it is there try to register it:
regsvr32 dtsconn.dll
HTH.