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 |
Explain index in sql server?
What is not null constraint?
Write a program to fetch first 10 records from a file?
How you can minimize the deadlock situation?
Can an entity have two primary keys?
How to find table changes in sql server?
Find first and last day of current month in sql server
What is save transaction and save point?
How you would rewrite the sql query to return the customerid sorted numerically?
Do you know query execution plan?
What r sql reporting services and analysis services? how can we use it.
How to drop an existing stored procedure in ms sql server?
Oracle (3259)
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)