February 6, 2008 at 10:57 pm
Hi,
I am getting an error while excel as the datasource type in the import/export task.
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 "{3202D5F6-2BE9-48E6-A340-0AF11BD66EEB}" 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.
({7CCAA790-6BB5-4778-805C-65E905CA6442})
------------------------------
The connection type "EXCEL" specified for connection manager "{3202D5F6-2BE9-48E6-A340-0AF11BD66EEB}" 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.
({7CCAA790-6BB5-4778-805C-65E905CA6442})
February 7, 2008 at 2:41 am
Hi,
This may be an oledb driver related issue in your box.
Can you Reinstall MDAC and Jet SP8 in your box.
Click the following link to download latest SP for Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
Regards,
Praveen
Be who you are and say what you feel,
because those who mind don't matter
and those who matter don't mind...
February 7, 2008 at 5:27 pm
Reinstall MDAC with the latest SP.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply