Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why Is DTS No Longer Client-Side Redistributable?

April 26, 2017client-side DTS longer redistributable

0

Posted

Why Is DTS No Longer Client-Side Redistributable?

1 Answer

0

Posted

DTS has been rewritten from a useful utility in SQL Server 2000 to a feature rich application and platform in SQL Server 2005. This change comes with a responsibility of providing service and support to DTS users best handled by managing and licensing the DTS engine functionality similar to other SQL server applications. Therefore, while users can easily deploy packages with the new Deployment wizard, they will be required to run the SQL Server 2005 setup and install DTS on each machine where they want to run the packages. This will not only help ensure the user/machine is using a correct version of the DTS executables but will also assist in updating the software in the future.