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
Differentiate between ms sql server reporting services vs crystal reports?
What are the advantages of stored procedure in sql server?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is default constraint?
What is the function of sql server agent windows service?
What is subquery explain with example?
Explain the phases a transaction has to undergo?
What is the difference between stored procedure and functions?
What is the difference between left and right outer join?
How to create an inline table-valued function?
What xml support does the sql server extend?
How to insert data into an existing table?
Explain the properties of subqueries in sql server?
What is merge replication?
Which tcp/ip port does sql server run on? How can it be changed?