what is Data Transformation Services (DTS) ?can u explain
me in detail?
Answer Posted / lakshmi
DTS is a kind of etl tool which extracts data from wide
range of sources like flatfiles,sql server,excel,oracle etc
and manipulating the data according to business logic by
using transformations before being loading into various
destinations.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is public role in sql server?
why would you call update statistics? : Sql server database administration
Why do you need a sql server?
What encryption security is available in sql azure?
How can you insert values in multiple rows using one Insert statement?
What are different types of schemas?
How to use subqueries with the exists operators in ms sql server?
Tell me about builtinadministrator?
Explain what is it unwise to create wide clustered index keys?
How many types of built in functions are there in sql server 2012?
Can sql servers link to other servers like oracle?
What are the encryption mechanisms in sql server?
How to write character string constants or literals in ms sql server?
What are system databases into sql server (2005/2008)?
What guidelines should be followed to help minimize deadlocks?