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 the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What are various ways to enhance the ssrs report?
Define left outer join?
Where is trigger in sql server?
How can we delete a table in sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
Explain can SSRS reports Cache results?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What are the different types of lock modes in sql server 2000?
What is unique key constraint?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Explain few examples of stored procedure over triggers?
What is a linked server in sql server?
What is measure group, measure? : sql server analysis services, ssas
What is single-user mode?