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

What are the extra roles available in msdb? : sql server security

0 Answers  

---

What is the simplest way to create a new database in ms sql server?

0 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---

Why use cursor in sql server?

0 Answers  

---

What is the correct order of the logical query processing phases?

0 Answers  

---

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

Is null vs coalesce?

0 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

What are the differences between user defined functions and stored procedures?

0 Answers  

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

---

Can you explain full-text query in sql server?

0 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---