what is DTS what are tasks available



what is DTS what are tasks available..

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How will you find out if there are expensive SQL statements running or not?

1 Answers   Atos Origin,


What is the default fill factor value?

1 Answers  


What is rtm version in sql server?

1 Answers  


What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,


explain different types of constraints? : Sql server database administration

1 Answers  


Different types of keys in SQL?

1 Answers   Infosys,


What is the need for group functions in sql?

1 Answers  


Explain time data type in sal server 2008?

1 Answers  


How to get max 100 values from sql server

7 Answers  


How to create a stored procedure with a statement block in ms sql server?

1 Answers  


What are key constraints?

1 Answers  


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1 Answers  


Categories