January 15, 2009 at 4:07 am
i have encountered an sissue in 64-Bit version of a script task. On further investigating, i have found that there is a property for a project
Run64BitRuntime is required to be set to false.
My question is:
if iam intending to install the package in the 64 bit machine and 64-Bit version of Integration Services is installed, will setting the it to false and make it 32 bit work?
To make it simpler, if the a package with 64Bitruntime is set false, work in a 64 bit environment?
January 16, 2009 at 6:39 am
See if this link helps. It covers a couple scenarios.
Greg E
January 19, 2009 at 7:53 am
If 64 bit runtime is set to false it will still run in 64 bit machine as a 32 bit mode. Which is equal to running under 32 bit version machine and it will be slower.
January 19, 2009 at 7:59 am
Thanks for the reply....
How do i find out the environment where the application is being deployed is 64-Bit? What message do i leave with the DBAs to find out?
January 19, 2009 at 8:04 am
By looking into OS properties you can find out that. I would prefer you to have two SSIS package one with 32 bit version (setting 64bitruntime to false) and other with 64 bit version and ask the DBA's to deploy the correct version based on the OS version.
When you have 64 bit version make sure that you don't have any excel source or destination. Excel sources will only work in 32 bit version or in 64bit version where the 64bitruntime is set to false. This is because the excel is a 32 bit version application.
January 19, 2009 at 8:20 am
Thanks for answering it with such an insight...
By default SSIS is configured to 64 bit runtime.
For example, i use a script task with
example 1:
default runtime 64 bit - precompilescriptintobinary is true - executed in 32 bit OS. What will it result into?
example 2:
default runtime 64 bit - precompilescriptintobinary is false - executed in 32 bit OS. What will it result into?
example 3:
default runtime changed to 32 bit - precompilescriptintobinary is true - executed in 32 bit OS. What will it result into?
example 4:
default runtime changed to 32 bit - precompilescriptintobinary is false - executed in 32 bit OS. What will it result into?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply