SQL Server Blogs

Voices from the UK SQL Server Community

Rob's SQL Server Blog

... SQL Server thoughts from the field

DTS Support in SQL Server 2005

Had a call this morning from a SQL Server developer looking to run DTS packages on a SQL Server 2005 machine with Integration Services installed. The user's problem was that he could not edit or run the DTS package via Management Studio. There is a simple solution to this problem, which involves Installing Design-time Support for SQL Server 2000 DTS Packages . This enables DTS packages to be opened or edited directly in BIDS or Management Studio.
When you install Integration Services, the legacy run-time components for DTS are installed automatically, but you still need to download the Microsoft SQL Server 2000 DTS Designer Components to edit the packages.  You do not need to tick the "Legacy Components" checkbox during SSIS set up. However, you will need to select this option during SQL Server set-up of you want to run DTS packages without installing Integration Services.


No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems