MMartin1 (5/20/2014)
In SSIS 2008, you can right click the Project (top node) in the VS solution explorer. From there go to Properties , Debugging , Run64BitRuntime... set this property to false. To run Excel, I'm sure you will of course need Excel installed on the client machine. See if it is similar in 2012.
The Run64bitRuntime property only works during design time (it is a visual studio property).
If you want a package to run in 32 bit on the server, you explicitly have to tell it to do so. You can do this by either launching the 32-bit version of DTEXEC, or by selecting a checkbox in the SQL Server Agent jobstep.
Office itself does not have to be installed on the server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP