Error exporting into Excel on 64-bit SQL Server

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)

Error exporting into Excel on 64-bit SQL Server

Author

Topic

imarchenko@hotmail.com
Starting Member

6 Posts

Posted - 2009-02-19 : 19:34:56

Hello!

I have following setup: SQL Server 2005 64-bit, 2-node cluster. Business Intelligence studio installed on both nodes. All SSIS packages are running fine on active node with exception of one. Package in question is exporting data into Excel file. I am able to run the package on passive node through BI studio after I set Run64BitRuntime property of the solution to false. I can also run using 32-bit version of dtexec:

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /f "d:\ssis\Packages\monthly_residential_sales.dtsx"

But when I try to run on active node using 32-bit version of DTExce, I am getting following error:

...
End Progress
Error: 2009-02-19 16:31:43.86
Code: 0xC0014019
Source: monthly_residential_sales
Description: The connection manager "Connection 2" will not acquire a connect
ion because the package OfflineMode property is TRUE. When the OfflineMode is TR
UE, connections cannot be acquired.
End Error
Error: 2009-02-19 16:31:43.88
Code: 0xC00291EC
Source: Drop Table Results Execute SQL Task
Description: Failed to acquire connection "Connection 2". Connection may not
be configured correctly or you may not have the right permissions on this connec
tion.
End Error
Warning: 2009-02-19 16:31:43.88
...

I check properties of the package and Offline property is set to False. I got different error when I try to run package on active node using 64-bit version of DTExec:

...
Error: 2009-02-19 16:33:16.33
Code: 0xC0202009
Source: monthly_residential_sales Connection manager "Connection 2"
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" H
result: 0x80040154 Description: "Class not registered".
End Error
...

Any help is greatly appreciated.

Thanks,
Igor

CTDBA
Starting Member

9 Posts

Posted - 2009-02-24 : 09:34:57

Can you give more details about connection 2?

Also, keep in mind that SQL 2005's 64 bit implementation is messed up in some ways. Even though the SQL engine is 64 bit, many components (specifically BIDS) are 32 bit. So if you develop something in BIDS, it will use the 32 bit drivers, but when you run it, it will look for the 64 bit ODBC drivers.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources