Answer Posted / s. elaiyaraja
DTS Used for various data transformations.
Not only between databases, its also used to transfers
data's between office excel,CSV, text files, MDB also.
Extracting data's from databases to Excel, mdb, csv, text
files.
We can extract the data's using Queries also(if its from
database).
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is openxml in sql server?
What is sql server 2000 work load governor?
What are the differences between web role and worker role?
What happens if you add a new index to large table?
What is factless fact table? : sql server analysis services, ssas
What is log in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the difference between an index and a unique index?
What is the maximum number of index per table?
Explain view in sql server?
Explain what is scheduled job and how to create it?
List out the differences between global and local temp tables in sql server?
What is difference in performance between insert top (n) into table and using top with insert?
What are entities and relationships?
How to integrate the ssrs reports in application?