THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Snack: SSIS, Excel, and a 64-bit OS

This blog has moved! You can find this content at the following new location:

Published Tuesday, January 19, 2010 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Keith Mescha said:

Andy great post, also note that when running the package remotely via a 3rd party job scheduler, etc. If your running on a 64bit instance of SSIS you can call the 32 version of dtexec.

Explained here with some good detail. This has bitten us before.

January 19, 2010 12:05 PM

Todd McDermid said:

But it will (likely) fail when you run it outside BIDS - gotta run the right DTExec for that.  (  (You don't mind me hijacking your blog, do you Andy? :) )

Second - Office 14 (aka 2010) WILL HAVE 64-bit DRIVERS!  (So said Douglas Laudenschlager...  Hooray!  Now if they can just get rid of the insanity of the Excel provider's "type inferring" behaviour...

January 19, 2010 12:16 PM

andyleonard said:

Thanks Keith and Todd!

  Have you guys been reading my posts scheduled for the future?

:{> Andy

January 19, 2010 12:23 PM

DrewskyJones said:

Also, as I understand it, with Office 2010 you can only have the 64 bit or the 32 bit driver on a machine, not both.  So this could be problematic if you wanted to design a package on the server in BIDS (using 32 bit driver) and then deploy to production on the same server using the 64 bit driver.  If anyone has heard something different I'd love to hear about it.


January 19, 2010 2:47 PM

AmosFiveSix said:

Great info in the post and comments (Hooray for 64-Bit Excel driver!)

Here are some notes that I collected while dealing with this and related 64-bit issues (with the links from these comments added in. Thanks guys!)

64 Bit SQL Server SSIS Packages with Excel and Access Data

More SQL Server 64-Bit Issues

January 20, 2010 8:32 AM

Jerry Dearbeck said:

THAT'S where that obscure "kicking my butt trying to do a simple access db extract" setting is!   Thanks Andy!  Say hello to the Dan-man for me while you're at it..

April 1, 2010 3:21 PM

Thejeswini said:

Thank you for the post. Great and very useful info

January 20, 2011 12:27 AM

Miki Breakwell said:

Thank you! Simple, straightforward and it worked.

June 6, 2011 5:01 AM

Kristina Moody said:

Exactly what I was looking for. Thanks!

April 12, 2012 5:52 PM

Jorge Rivera said:

Muchas graciss. Justo lo que estaba buscando.

November 14, 2012 5:43 PM

andyleonard said:

De nada, señor.


November 14, 2012 5:50 PM

Rahul Agrawal said:


Its work


February 23, 2014 7:44 PM

Martin said:


August 31, 2015 10:48 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement