Technical Tips and Solutions
01/02/2008 - Where has my SQL Server DTS gone?
If you have recently upgraded from SQL Server 2000 with Enterprise Manager to SQL Server 2005 with Management Studio you may wonder where your DTS has gone. In Enterprise Manager it was possible to right click on a table and choose All Tasks/Export Data. In Management Studio this option is not available. Fortunately, despite all the goings on about DTS being changed to SSIS the functionality has just been confined to the root database object in the explorer. Here you can indeed right click, choose Tasks/Export Data to access a very DTS like window!
SQL Server, DTS, Import, Export, Enterprise Manager, Management Studio, data, right click, tasks