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

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

What are the advantages of mirroring?

0 Answers  

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

How do I save a stored procedure in sql server?

0 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---

Explain sql server authentication modes?

0 Answers  

---

Can we hide the definition of a stored procedure from a use?

0 Answers  

---

How are the unique and primary key constraints different?

0 Answers  

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

---