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 index in an assignment?
How to drop an existing user defined function in ms sql server?
What are dml (data manipulation language) statements in ms sql server?
List out the difference between union and union all in sql server?
What is normalization? What number of normalization shapes are there?
What is a scheduled job or what is a scheduled task?
Do you know what are various aggregate functions that are available?
What do you mean by an execution plan? Why is it used? How would you view it?
What is the data type of time?
How to generate create view script on an existing view?
What are different types of raid configurations? : SQL Server Architecture
Name few of the dcl commands in sql?
What are the common performance issues in sql server?
How do I setup a local sql server database?
Difference between primary key and clustered index?