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
How to achieve Paging of records in SQL SERVER?
Explain tables in SQL Azure?
What is apply operator in sql?
What do you understand by mirroring?
How to recover from sql injection? : sql server security
What are the elements of dbms?
What is the synonym of join?
Explain iaas, paas and saas?
How can sql server instances be hidden? : sql server security
What is difference between count (*) and count 1?
Explain alternate key, candidate key and composite key in sql server?
What are the methods used to protect against sql injection attack?
What are the tools available in market as an alternative to sql server reporting services?
What is left outer join in sql server joins?
Why use view instead of a table?