Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSIS Basics: Running a Package in 32 Bit Mode

  • 29 November 2011
  • Author: ShawnHarrison
  • Number of views: 69046
  • 0 Comments

These days, everything seems to be 64 bit. As technology advances and costs start to come down, businesses are easily moving their IT systems to 64 bit hardware. There is one little issue with that. In SQL Server land, there are some things that still need to be done in 32 bit.

 

In SSIS, there are a few tasks that cannot run in 64 bit. The four most common are the Active X script task, the Execute DTS 2000 package task, the Excel Source, and Excel Destination. The first two, you shouldn?t be using anyway, but the last two are just necessary sometimes. In the event you need to have these, you will have to run the package in 32 bit mode. There are two places you need to do this; BIDS and in a scheduled job. I will show you how to enable this in both places.

 

I am sure you will want to test your packages in BIDS, before you deploy them. If you are using a 32 bit component, you will have to set the project to 32 bit runtime. That?s right, the whole project. To do this, in the tool bar, click Project > {ProjectName} Properties.

 

image

 

On the properties page, click on Debugging on the left side. Here, you can see an option that reads ?Run 64 Bit Runtime?. This is set to True by default. Click the drop down and select False. Click Apply and OK. Now, you can run the package in BIDS.

image

 

Keep in mind, this sets the every package in the project to 32 bit. You may want to restore 64 bit runtime after testing is complete.

 

Once you deploy and schedule a package, you have the option to run just that one package in 32 bit. When creating the step in your scheduled job, you will see a series of tabs. After selecting your package, click on the ?Execution Options? tab. At the bottom of the tab, you will see a check box that will run the package in 32 bit mode. See the screen shot below.

image

 

These are the two most common ways to run a package in 32 bit.

Print
Tags:
Rate this article:
4.3

ShawnHarrisonShawnHarrison

Other posts by ShawnHarrison

Please login or register to post comments.