adspace


what is DTS what are tasks available

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between openrowset and openquery?

1197


What are the different SQL Server Versions you have worked on?

1080


List the ways in which dynamic sql can be executed?

1088


What are the different subsets of sql?

1655


How to rebuild the master database?

1167


What is a coalesce function?

1285


What is normalization and what are the advantages of it?

1057


do you know how to configure db2 side of the application? : Sql server database administration

1125


How to enter binary string literals in ms sql server?

1246


Why use identity in sql server?

1203


Equi join and non equi join is possible with sql server?

1134


What is sql server query analyzer?

1131


What is the difference between upgrade and migration in sql server?

1185


What are wait types?

1251


What is acid mean in sql server?

1247