Answer / seshagiri

DTS is set of graphical tools and programmable objects,
using that we can extract,transform, and consolidate data
from source in to multiple destinations.

Tasks are....

Transform Data

Copy and Manage Data

Function as Jobs

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

How to Check if table exists in sql server?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

How can you insert null values in a column while inserting the data?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

---

Is oracle faster than sql server?

0 Answers  

---

internal language used in sql server 2000?

2 Answers  

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

Do you know how to make remote connection in database?

0 Answers  

---