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,
Try to refresh your connection manager or recreate a manager. Seems like when you move the package the connection properties got lost.|||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 ...
|||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?
|||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.
|||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
|||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.
No comments:
Post a Comment