Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between a local and a global temporary table?
How sql server enhances scalability of the database system?
How to connect to SQL Azure Database by using sqlcmd?
What is sql server english query?
What is de-normalization in sql database administration? Give examples?
Explain the properties of the relational tables?
What are truncate options available in sql server? : sql server database administration
Which tools are available to manage SQL Azure databases and servers?
What should be the fill factor for indexes created on tables? : sql server database administration
What are the different types of collation sensitivity in sql server?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
can an order by clause be used in a creation of a view?
How to use subqueries with the in operators in ms sql server?
How can windows applications connect to sql servers via odbc?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
