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

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

How to remove duplicate rows from table except one?

0 Answers  

---

Explain view in sql server?

0 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

---

How to connect ms access to sql servers through odbc?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Explain transaction server consistency?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

Can two different columns be merged into single column? Show practically?

0 Answers   QuestPond,

---

How to choose all records from the table?

0 Answers  

---