RE: How to run Deployed Pkg's at 64 bit

SSCertifiable

Points: 5505

July 11, 2018 at 3:42 pm

#1997232

frederico_fonseca - Wednesday, July 11, 2018 3:23 PM
If you run the package through a sql server agent job, within a step defined as Integration Services Package there is a tick box on the advanced properties to elect it to run as 32 bit - by default it will run under the type of install - if SQL install is 64bit it will run as 64bit unless this box is ticked.
If running from the command line the same applies but on this case a parameter is supplied to force to 32bit if running on a 64bit server.

I already have it with that 32 bit switch turned off, if I turn t on, then it will error. How can i check to validate that when it is running that its at 64 bit then? when I run one of my jobs, and look at network traffic, its half that of others who are pulling in data at a known 64 bit. This has been a long term problem with someone before me not setting up the server quite right, but also a single box thats used both for Dev and Prod