WORKING WITH DTS IN SQL 2008 32-BIT VERSION
![run sql server management studio 17 64 bit run sql server management studio 17 64 bit](https://blog.sqlauthority.com/i/b/ace-error-01.jpg)
Nothing prevents you from doing this, and we have found the performance of this new configuration to equal that of our previous setup. We simply chose to continue hosting the DTS packages on our old production 32-bit SQL Server 2000 box and simply change the Source and Destination connections to the new 64-bit SQL 2008 environment. We did not like this option as there are times when you want to run packages interactively and be able to edit them for troubleshooting purposes. Note: Remember to change the Source and Destination connections where necessary to the new 64-bit machine. One option around this limitation is to edit the DTS package locally or on a 32-bit server and then copy the package over to the 64-bit machine.
#Run sql server management studio 17 64 bit install#
So while it is possible, on a 64-bit machine, to install a 32-bit version of the dtexec utility (dtexec.exe) that allows you to run the DTS packages in 32-bit mode, the utility does not allow you to edit the packages. Like many companies, we wanted our new production servers to gain the performance increases from running the 64-bit edition of SQL 2008. WORKING WITH DTS IN SQL 2008 64-BIT VERSION If you are planning an upgrade to SQL 2008 and are not ready to head down the SSIS path here are some ideas to accommodate your existing DTS packages.
![run sql server management studio 17 64 bit run sql server management studio 17 64 bit](https://s33046.pcdn.co/wp-content/uploads/2020/01/downloading-the-sql-server-2019-express-install-pa.png)
We knew pre-upgrade that the functionality of many of our DTS packages would soon become obsolete (in a few months) and so this did not warrant the time and expense of converting them to SSIS. Recently, we were faced with the not uncommon situation of upgrading our SQL 2000 production system directly to SQL 2008 (and bypassing SQL 2005).