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
