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 data source view or dsv? : sql server analysis services, ssas
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the difference between substr and charindex in the sql server?
What is model database? : SQL Server Architecture
Do you know what is difference between index seek vs. Index scan?
What is implicit mode in sql server?
Indexes are updated automatically is the full-text index also updated automatically?
How sql server enhances scalability of the database system?
What are types of subqueries?
Why are you getting errors when creating a new odbc dsn?
Do you know what are various aggregate functions that are available?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the difference between drop table and truncate table?
How retrieve field names from the table in SQL through JAVA code?
What are “lost updates”?