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

Explain me what is vldb?

0 Answers  


What is your spectra photometer working principles?

0 Answers  


difference between For each and for all

2 Answers  


What are the advantages of raid 1, 1/0, and

0 Answers  


What is the purpose of Dataware Control?

0 Answers   CGI,






Define data warehouse?

0 Answers  


How to create diff. Types of templates?

0 Answers  


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  


Can you brief about the Data warehouse project you worked on?

0 Answers   Deloitte, TCS,


what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 Answers  


Why should you put your data warehouse on a different system than your oltp system?

0 Answers  


Which one among Star and snowflake schemas will occupy more space?

1 Answers   Barclays,


Categories