Ssis on 64 bit windows

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings.

However, sometimes you need your packages to run in x86 mode. As well, especially with BIDS, if you want to debug and use breakpoints with your C code in your Script Task or Script Component, you must debug your package in x86 mode or else breakpoints will be skipped over. Many times, desktop machines and servers only come with the x86 versions of Office drivers. If your packages read or write to Excel documents or Access databases, you may need your package to run in x86 mode. Alternately, you can download the x64 Office drivers or install the x64 version of Office.

You may need to do some digging about how to install x86 and x64 versions of the Access and Excel drivers on the same machine.

Remember, you can only install the x86 or x64 versions of Office on a machine — not both. Try rerunning the package in the opposite mode x86 or x64 and see if the error goes away.

Submit a Comment Cancel reply Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Clarifying Information. Error code: 0x Defect Number. Enhancement Number. But when the bit Provider tries to read from the registry, x64Windows knows the dll is bit, and does not try to look in the WowNode part of the registry.

The bit Provider will then not need the full path. Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service.