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

Is sql different from sql server?

0 Answers  


What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  


How to read data in a table with "select" statements?

0 Answers  


Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  


What is the largest component inside a field?

0 Answers  






What is transact-sql language?

0 Answers  


Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,


How can I know what locks are running on which resource?

0 Answers  


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


How to connect sql server management studio express to sql server 2005 express?

0 Answers  


Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,


How do I create a trace in sql server?

0 Answers  


Categories