The Excel Connection Manager is not supported in the 64-bit version of SSIS

When you attempt to execute an SSIS package which has a Excel
Destination/Source in SQL Server 64 bit , you will get following error.

[Connection manager "Excel Connection Manager"] 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.

As error suggests, the Excel Connection Manager does not support the
64 bit version. However, depending on the environment you can still execute SSIS
packages.

SQL Server Agent Job

In SQL Server 2008, there should be a checkbox on the Execution
options tab Job Step page to run the package in 32-bit mode as shown in
following image:

DTEXEC

Alternatively, in SQL Server 2005, you can change the Job Step from an
Integration Services Step to an Operating System step and specify a DTEXEC
command line instead.  The DTEXEC command
line needs to specify the DTEXEC.EXE from the Program Files (x86) folders, NOT
the DTEXEC.EXE from the Program Files folders which is the 64 bit version.  If you’re executing the package you
therefore need to specify the 32-bit version of DTEXEC by explicitly running the
DTEXEC.EXE from the Program Files (x86) SQL Server folder.

Visual Studio

You can also set the 32 bit runtime environment using
Project Properties -> Debugging -> Run64BitRuntime = False, as shown in
the following image.




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |