Getting Error in 32bit DTEXEC on 64bit machine

I'm getting

will not acquire

a connection because the package OfflineMode property is TRUE. When the Offline

Mode is TRUE, connections cannot be acquired."

I'm running the 32bit DTEXEC on a 64bit machine since I'm using the Jet provider.

I see in the forum and other places that this error usually occurs when you try to run in 64bit.

I don't get this error when I've tried it, running the 64bit DTEXEC or when I run from BIDS on a 32bit machine.

Any help appreciated.

David

Hi, We are investigating this particular issue. Its unclear the various conditions/configurations which cause this to happen as in general what your attempting to do does work. As a work around try populating the package property OffLineMode as true with a configuration.

Thank you for your patience.

|||

Apologies, a compatriot pointed out I mistyped, and it should be false not true.

|||

The error is misleading. Two possible solutions. 1) try reinstalling the client tools. 2) Use package configuration to force System::OfflineMode = False

</DTSConfigurationHeading><Configuration ConfiguredType="Property" Path="\Package.Properties[OfflineMode]" ValueType="Boolean"><ConfiguredValue>0</ConfiguredValue></Configuration></DTSConfiguration>

|||

Solved.

We solved the issue by reinstalling just the client components onto the SSIS server.

This replaces the 32bit DTEXEC and now works.

What gave us a clue is the SSMS couldn't connect to the SSIS Service.

David