Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation

No, it is not as bad as that. KB 810927 is about SQL Server 2000. Here is
a KB on 2005:
http://technet.microsoft.com/en-us/library/ms141766.aspx

The tips for running 32-SSIS packages can be extended to running 32-bit DTS
packages. Simply create a SQL Agent job with an Operating System job step
and run:
DTSRUN your package parameters.
Since DTSRUN is a 32-bit executable it will run in 32-bit Windows-On-Windows
(WOW) on a 64-bit server. The one thing to look our for in running 32-bit
packages is the location of some executables.

64-Bit
Windows\System32
Program Files

32-bit
Windows\SysWOW64
Program Files (x86)

In order to maintain the ability to edit these DTS packages, read:
http://technet.microsoft.com/en-us/library/ms143755.aspx. See the note on
downloading theDTS package designer.

I am happily running 64-bit SSIS, 32-Bit DTS, etc, etc, without any
problems.

RLF


"Sebastian Waksmundzki" <sebwaks@xxxxxxxxxxx> wrote in message
news:%23nubQSOGIHA.5328@xxxxxxxxxxxxxxxxxxxxxxx
*** C. wrote:
Hi

Hello

Have a look here There are some bad news for you
http://support.microsoft.com/kb/810927


in a nutshell the DTS runtime and its designer tools are not available
on the 64-bit platform. You can read data from and write data to a
64-bit system from a 32-bit system running DTS, and you can physically
store your DTS packages in a 64-bit SQL Server database. But the DTS
packages themselves will not run on the 64-bit platform.

regards
SW


We have SQL Server 2005 Standard Edition Running on a 64-bit processor.
We have been unable to get the DTS Designer to open and edit packages. I
have tried installing the Web download it says to install but then I get
an error saying the package could not be read. The message points to a
KB article that talks about removing a dependency in a config file but
this dependency does not exist on the server.

(Sorry I am typing from memory I don't have access to the server right
now).

Is it possible to edit DTS Packages on a 64-bit SQL Server 2005
installation?

-***





*** Sent via Developersdex http://www.developersdex.com ***


.