Error source excel and destination sql

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 2008 Forums

SSIS and Import/Export (2008)

Error source excel and destination sql

Author

Topic

sarahmfr
Posting Yak Master

214 Posts

Posted - 2012-01-02 : 12:48:55

Please I need help.

I was able to import an execl 2003 file to my database from within sql manager but When I used ssis I got an error message.
Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
I saved the file as excel 2007 I got a different error message
The microsoft ace.oledb.12.0 provider is not registered on the local machine
although microsoft.ace.oledb.12.0 is one of the providers under linked servers in server objects in the sql server

sarah

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-02 : 12:58:10

for first error you need to set 64bitruntime property to false in SSIS project propertie debugging tab

see
http://visakhm.blogspot.com/2011/12/dtexec-issues-running-ssis-packages-in.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sarahmfr
Posting Yak Master

214 Posts

Posted - 2012-01-02 : 13:17:55

Thanks a lot

sarah

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-02 : 13:21:28

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources