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
What are the triggers in sql?
What are the events recorded in a transaction log?
What are the transaction properties?
What do we need queues in sql service broker?
How to connect sql server management studio express to sql server 2005 express?
What are the types of resultset?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
what are the different ways to return the rowcount of a table?
What are various ways to enhance the ssrs report?
Why do we need different type of parameter?
What is the use of partition by in sql server?
between cast and convert which function would you prefer and why?
Where is trigger in sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
