http://www.sqlservercentral.com/blogs/dknight/2009/12/11/running-ssis-32_2D00_bit-drivers-or-tasks-on-a-64-bit-machine/

Printed 2014/09/02 09:47PM

Running SSIS 32-bit drivers or tasks on a 64 bit machine

2009/12/11

Running SSIS on a 64-bit machine has several caveat that developers need to be aware of.  Tasks like the ActiveX task and Execute DTS 2000 Package Task only work either on a 32-bit machine or by running in 32-bit mode on a 64-bit machine.  This is also the case for many data providers like Excel, Access, and many ODBC drivers.  If you are working on a 64-bit machine don't worry there is a work around to keep yourself productive while still using 32-bit tasks and drivers.

Executing In BIDS

 

Executing On Server

SQL Server 2008

SQL Server 2005

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.