About DTS usage ?
Answers were Sorted based on User's Feedback
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 |
Answer / kinthada cnu
hi all
DTS : Data Transformation service.using DTS object transfor
the data from one database into anothert database.
ex:sqlserver to orcale or ms-acces.....
| Is This Answer Correct ? | 1 Yes | 0 No |
Why do we need different type of parameter?
What is sql view?
What are the difference between primary keys and foreign keys?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
What is openxml in sql server?
What is tcl in sql server?
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
What is a field name?
What does man by sql wildcard characters in sql server?
How do we get month name in SQL Server 2000, Oracle, MS Access?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is difference between stored procedure and function?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)