I'm enountering the same problem many have previously reported.
Running SQL Server 2005 x64 on Windows Server 2003, and I can't use a
Data Flow Task in SSIS where the destination in an Excel spreadsheet
because there is no 64-bit JET driver for Excel.
Is anyone aware of a 64-bit driver now available or any 3rd party
options? Running the entire package in 32-bit mode is not a
possibility, so I can't use the DTExec workaround.
Any assistance would be appreciated --
Jamie
> Running SQL Server 2005 x64 on Windows Server 2003, and I can't use a> Data Flow Task in SSIS where the destination in an Excel spreadsheet
> because there is no 64-bit JET driver for Excel.
> Is anyone aware of a 64-bit driver now available or any 3rd party
> options? Running the entire package in 32-bit mode is not a
> possibility, so I can't use the DTExec workaround.
You can vote here:
Microsoft Connect > SQL Server: x64 Jet provider
http://connect.microsoft.com/SQLSer...=12511
7
No comments:
Post a Comment