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 |
How to get a list of columns in a view using the "sp_help" stored procedure?
How can we check the sql server version?
How can sql server instances be hidden?
How do you trace the traffic hitting a sql server?
How to get all stored procedures in sql server?
What are ddl (data definition language) statements for tables in ms sql server?
What is a collation in ms sql server?
Give an example of SQL injection attack ?
What are the different normalization forms?
How to resolve the orphan use problem? : sql server security
I have student marks in a student table. I need second highest mark .Then what will the query for this?
37 Answers NetCore, Patni, SAP Labs, Temenos, Wipro,
If no size is defined while creating the database, what size will the database have?
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)