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 thepackage 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

I had exactly the same problem after installing Cumulative Update 8 for SQL 2005 SP2 x64. Running the following command on the server as described in http://support.microsoft.com/kb/919224resolved it for me: %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"

Don,This last step (the re-registering of the dts.dll) did the trick for us. We recently upgraded from SQL 2005 enterprise on a clustered 64 bit platform to SQL 2008 enterprise 64 bit on SP1.Thanks very much!

Just wanted to say they I just noticed this issue one one of my "test" clusters instancesRan%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll" the problem went straight away.Thank you Don

Hello, I get this error message while trying to delete a SSIS package. Is there anyother way than re-registering the DLL.Suman

Registering the dts.dll did the trick. %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll" Thanks JIM