Question:
what is DTS(SQL)?
nambiind
2006-04-03 05:13:38 UTC
what is DTS(SQL)?
Four answers:
timmytude
2006-04-09 21:53:51 UTC
DTS is available in SQL 2000. It stands for Data Transformation Services. It is (or was) a use fuel tool for importing data from one source to another. Like from an Access, SQL, Oracle, PHP DB, or a flat file or spreadsheet into a SQL Database - or whatever. Once a DTS package is created, you could then create a job that will automatically run the package on a set schedule - for example you may want to import new records from one table to another table every night. But DTS isn't in SQL 2005 - but you can still use old DTS packages with 2005. The new technology is SQL Server Integration Services (SSIS).
2006-04-03 05:19:42 UTC
DTS stands for data transformation services, it comes with sql server, it allows you to obtain data form xml files, excel files etc. you can query an excel file.



http://www.microsoft.com/technet/community/events/sql2000/tnt1-78.mspx is a list of demos you can see
Andyste
2006-04-03 05:19:17 UTC
well DTS was Digital theater system

and SQL was standard Query language



Don't know how you got them together
Fatatta
2006-04-03 05:17:03 UTC
whaa?


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...