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 is a mutating table error and how can you get around it?
How to set the current database in ms sql server?
What is conditional split?
what exactly sql injuction.how to overcome.....
Is it possible to replicate data from sql server to oracle? : sql server replication
How to locate and take substrings with charindex() and substring() functions?
What do you understand by hotfixes and patches in sql server?
What languages bi uses to achieve the goal?
How to delete duplicate rows?
What is user-defined inline table-valued function?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Explain left outer join and right outer join?
What is query optimizer in sql server?
What is index in an assignment?
What is transaction server isolation?