Geek Answers Handbook

64 bit SSIS run64bitruntime

I developed the SSIS package on a 32-bit machine using the trial version of Microsoft Visual Studio Ultimate 2012, I deployed this package to a 64-bit machine for processing. I cannot change run64bitruntime to true, this field is disabled and I cannot change it to true. How to enable this field so that I can change it to true.

+4
source share
4 answers

Maybe someone will find this useful ...

You can change the run64bitruntime parameter to the runtime (SQL Server job) using:

SQL Server Agent->Jobs->Job Step Properties->General->Execution Options

enter image description here

+4
source

The SSIS development environment is a 32-bit environment. During development, you only have access to 32-bit data providers, and as a result, you can only attract those 64-bit providers in your SSIS projects, which also have a 32-bit version available on the development machine.

On the other hand, the SSIS runtime is dictated by the underlying operating system, which means that regardless of the vendor version that you used at design time, the correct version will be used at run time. This is true when the package is started by SSIS, as well as when starting the package from SSDT

This way, you can control the version of the providers that will be used explicitly, by running the Run64BitRuntime project ONLY during development.

+1
source

Explicit management of the 64-bit RUNTIME environment ....

  • Project properties
  • Select Configuration Properties
  • Select "Debug"
  • Select debug options
  • Set Run64BitRuntime to TRUE
0
source

XLSX files have created problems in the past, and XLS cannot be used with 64-bit. Therefore, all tasks work with 32 bits, as in the answer of Andrey Morozov.

Our working machines were 32 bits, and when I received x64 windows, I needed to debug all the packets in 32 bits. I am lazy to set the option for all packages manually, so I found that it is saved in the ".user" file.

I wrote this little C # Script to change:

 foreach (FileInfo myFile in new DirectoryInfo(@"PATH TO OUR SSISPROJECT SHARE") .GetFiles("*.dtproj.user", SearchOption.AllDirectories)) { TextReader textR = myFile.OpenText(); String fileContent = textR.ReadToEnd(); textR.Close(); if (fileContent.Contains("<Run64BitRuntime>true")) { fileContent = fileContent.Replace("<Run64BitRuntime>true" , "<Run64BitRuntime>false"); } else if (!fileContent.Contains("<Run64BitRuntime>") && fileContent.Contains("<Options>")) { fileContent = fileContent.Replace("<Options>" , "<Options>\r\n <Run64BitRuntime>false</Run64BitRuntime>"); } else { continue; } TextWriter textW = myFile.CreateText(); textW.Write(fileContent); textW.Close(); }

kindly welcome

0
source

More articles:


All Articles