I seem to remember it taking some effort to get the DTS components working
in SQL 2005 x64. And there were some error messages the first time I
edited an existing package. Some of the icons were invisible, but passing
the mouse over them, or clicking to select them, made most of them visible.
After I had saved the packages once, the icons stayed visible and the error
message did not recurr.
I did not find any server problems from installing the DTS components onto
the SQL 2005 x64 server. DTS is both the developer portion and the runtime.
You can keep the developer parts on a workstation and just install the DTS
runtime on the server. There used to be a separate redistributable for the
DTS runtime.
The error was "SQL Server 2000 DTS Designer components are required to edit
DTS packages. Install the special web download 'SQL Server 2000 DTS Designer
Components' to use this feature". I said ok to that error and was then able
to edit the package. I
could see the connecting lines, but not the nodes. Sometimes when I just
passed the mouse over a node, or clicked on it, the icon would appear. After
editing and saving the package the first time, it looked, worked and edited
fine after that. This was a very simple package so I could tell what was
where just by guessing.
Here's a post from Mark Han, a SQL engineer, which might help:
"In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.
2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.
B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you: http://msdn.microsoft.com/en-us/library/ms143755.aspx
C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:
http://msdn.microsoft.com/en-us/library/ms138023(SQL.90).aspx
Besides, I do some additional research for you: There is an article to
share with you: http://msdn.microsoft.com/en-us/library/ms162810.aspx
Post by SteveHi
I have been asked to install sql server 2000 dts designer components
on a 64bit SQL 2005 server. The 2005 server is a production server and
I am concerned about installing a v2000 developer tool on this server.
Does anyone have any advice on whether this is recommended or not.
Thanks
Steve