Hi all,

Could anyone help me with issues I'm having with the reverse scenario - I'm trying to create an SSIS package to write from SQL 2008 TO an Excel xlsb file? Can this be done?

I've been reading around, and the common answer seems to be to create the package to write to an xlsx file, and then simply tweak the connection string to point at the xlsb file instead.

I've tried this, and the modified connection string on my Excel Connection Manager is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Test\FolderName\Filename.xlsb;Extended Properties="Excel 12.0;HDR=YES";

With Excel file path: C:\Test\FolderName\Filename.xlsb

When I execute my package, I get this error:

[Excel Destination [558]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Am I missing something simple, or just trying to do something which can't be done?