BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
If you're using SSIS to import from or export to Excel workbooks or Access tables - as you surely will be - you'll need to run your packages in 32-bit mode. This blog explains why and how to do this.
- Integration Services Problem Importing Excel/Access Data
- Running Packages as 32-Bit in Development
- Running your Packages as 32-Bit on the Server (this blog)
Posted by Andy Brown on 08 January 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Running your Packages as 32-Bit on the Server
When you've deployed your packages (I'm assuming you're using project-level deployment in SSIS 2012 or later), you also need to be careful to execute them in 32-bit mode.
You can right-click on a deployed package to run it.
The symptom of the problem
You can see that I ran this report 3 times before I found the answer to my problem:
The package failed 3 times, but is now working.
If I look at the error messages, they're really not that helpful:
These errors shed almost no light on the subject.
The solution
When you choose to execute your package, a dialog box appears. You need to tick a tiny little box!
On the Advanced tab, be sure to tick the 32-bit runtime box shown.
I think it's fair to say that this is easy to overlook!
If you're using a stored procedure to run your package, the auto-generated script will include a parameter called @use32bitruntime, which you can set to True.
- Integration Services Problem Importing Excel/Access Data
- Running Packages as 32-Bit in Development
- Running your Packages as 32-Bit on the Server (this blog)