What is DTS ?



What is DTS ?..

Answer / azhar

DTS stands for Data Transfer Services. It was introduced in
sql server 7.0.
In sql server 2000 DTS was a bit advanced by adding
scripting like VB Scripting. Previously DTS was a wizard
kind of thing so now DBA's were finding it difficult to
write the scripts which was easily done by developers.In
2005 it came as Integration Service.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

How do you setup Lo-cockpit?

1 Answers  


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

1 Answers   IBM,


what is indexing ? what are different types of indexes supported by oracle ?

2 Answers  


What is vdl (view definition language) explain?

1 Answers  


What do you mean by static and local variable?

1 Answers  


What is the difference between star and snowflake schemas?

1 Answers  


Best institute for MS BI training in Hyderabad, India?

4 Answers  


What is data validation strategies for data mart v?

1 Answers  


Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1 Answers  


What is a general purpose scheduling tool?

1 Answers  


What is the difference between OLAP, ROLAP, MOLAP and HOLAP?

2 Answers  


difference between bo 6.5 and bo xi r2

3 Answers   Accenture, Polaris,


Categories