Answer Posted / 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 View All Answers
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How can we run the graph?
Explain hybrid slowly changing dimension?
what are the different views that are considered when building an object-oriented software system?
what are the others of "bad files" and "discard files" when using sql*loader?
What is edw?
What is is a star schema?
What is a view as it relates to system modeling?
Explain what is the difference between power center & power mart?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What are templates in which way it is help full?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is the difference between view filter and report filter?
Explain what are the various transformation available?
How to get the first 100 rows from the flat file into the target?
