I got the following error when importing file to sql server 2005. I reinstalled the MDAC as well.
Please help.
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 "{E3861233-443A-439A-BB8D-2777D84DB343}" 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.
({C3728B0D-B172-4246-9B14-6EEDAB60F191})
The connection type "EXCEL" specified for connection manager "{E3861233-443A-439A-BB8D-2777D84DB343}" 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.
({C3728B0D-B172-4246-9B14-6EEDAB60F191})
BUTTONS:
OK
Have you removed any connection manager that was used by some task(s)?
Since the error message shows the ID of the connection manager; it looks like that a connection manager was delete it but the references to it have not been removed. Make sure all tasks/source/destiantions in the mapping are pointing to a valid connection manager.
|||what do u mean by connection manager? I've no idea.|||Ok. Let's back to the basics. How did you create the package? are you running it in BIDS?|||Could you tell us what version of SQL Server you have installed (RTM, SP1, SP2)?
Also, could you describe how you configured each page of the Import/Export wizard?
Thanks,
Bob
|||I am having the similar problem: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1867309&SiteID=1
I would like to provide a greater detailed info if needed. I am looking for solutions.
No comments:
Post a Comment