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 |
You are doing log shipping due to some reasons it is failing. How you will proceed from there
Why use sub query in sql server and list out types of sub queries?
Which are the new data types introduced in sql server 2008?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
0 Answers Amdocs, Apps Associates,
What is policy based management (pbm)? : sql server database administration
What is delete query?
What should be the fill factor for indexes created on tables? : sql server database administration
What is the use of partition by in sql server?
Explain DBCC?
What is the syntax for encrypting a column in SQL Server?
What is a trigger?
Can you name a few encryption mechanisms in 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)