Browse by Tags

Making SSIS work with the 64-bit Excel (ACE) provider

Published 1 September 10 11:50 AM | dougbert

I've previously blogged about the challenges of the new 64-bit ACE Provider that includes the Excel driver, since the 32-bit and 64-bit versions cannot be installed side-by-side. In this detailed post that includes screen shots, Hrvoje Piasevoli from...

Filed under: known issues, Excel, 64-bit

Download beta of new 64-bit Excel driver

Published 5 April 10 6:43 AM | dougbert

<tap><tap> Is this thing on? If you've been curious to test the 64-bit version of the provider and driver for Excel, you can download it from: http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang...

Filed under: Excel, 64-bit

64-bit Excel Driver in Microsoft Office 14

Published 28 August 9 3:6 PM | dougbert

First, the good news... If you use SQL Server Integration Services to load data to or from Excel files or Access databases, then a 64-bit driver is headed your way. This is great news for SSIS users in a 64-bit world. Soon you'll be able to run your...

Filed under: Excel, 64-bit, connectivity

Debug your packages in 32-bit or 64-bit mode

Published 16 March 9 12:28 PM | dougbert

At run time, you decide the "bitness" of Integration Services package execution on a 64-bit computer by running the 32-bit or the 64-bit version of the dtexec.exe command prompt utility. At design time in Business Intelligence Development Studio...

Filed under: 64-bit, BIDS

64-bit Considerations for SQL Server Integration Services

Published 10 June 8 10:31 AM | dougbert

Herewith my best effort to restate the contents of the Books Online topic, 64-bit Considerations for Integration Services , more simply and cleanly. Unfortunately the BOL topic has become quite messy over time, as one bandage is applied over another,...

Filed under: setup, DTS, 64-bit