Answer / 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).

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.....

write coding for importing sql data into a word excel...

1 Answers   Oracle,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

When would you use sql joins?

0 Answers  

---

What is the difference between clustered index and primary key?

0 Answers  

---

how to find 6th highest salary

0 Answers   Chetak Logistics,

---

---

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

What is the fillfactor concept in indexes?

0 Answers  

---

What are three major types of constraints?

0 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

What are the transaction properties?

0 Answers  

---