An error occurred which the SQL Server Integration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

An error occurred which the SQL Server Integration

Author

Topic

toxic.karan
Starting Member

2 Posts

Posted - 2008-02-07 : 00:43:51

Hi Team,

I am having a problem in importing excel data (.xls)into a database in SQL 2005. I am recieving this error. Please help me out.

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 "{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})

------------------------------
BUTTONS:

OK
------------------------------

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-07 : 00:59:14

How did you run the wizard step by step?