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
February 7th, 2007 5:10pm
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.
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2007 12:43am
Apologies, a compatriot pointed out I mistyped, and it should be false not true.
February 9th, 2007 1:01am
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>
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2007 8:44am
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
February 9th, 2007 9:59am
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"
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2008 4:30pm
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!
January 25th, 2010 11:50am
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
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2010 6:40am
Hello,
I get this error message while trying to delete a SSIS package. Is there anyother way than re-registering the DLL.Suman
March 9th, 2011 4:18am
Registering the dts.dll did the trick.
%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"
Thanks
JIM
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2012 2:31pm