Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DTS tools

Author  Topic 

sqlvijay
Starting Member

16 Posts

Posted - 2009-04-08 : 08:55:19

Hi Everybody
I am new to sql server.
In my application , i´m using DTS, however I can’t run these because the server, don’t have the tools to let me do it.
What should I need to install on the server to make dts available.
where to get dts software?

please share your ideas.

Thanks in Advance
vijay.S

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2009-04-08 : 09:10:08
DTS has been replaced by SSIS designed in visual studio. You can import legacy DTS's. To view /edit them you need to download "Microsoft SQL Server 2000 DTS Designer Components" at:
http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Sql server 2005 has a conversion tool also.
Go to Top of Page
   

- Advertisement -