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


Please Help Members By Posting Answers For Below Questions

What is public role in sql server?

621


why would you call update statistics? : Sql server database administration

662


Why do you need a sql server?

586


What encryption security is available in sql azure?

85


How can you insert values in multiple rows using one Insert statement?

692






What are different types of schemas?

601


How to use subqueries with the exists operators in ms sql server?

673


Tell me about builtinadministrator?

646


Explain what is it unwise to create wide clustered index keys?

606


How many types of built in functions are there in sql server 2012?

579


Can sql servers link to other servers like oracle?

540


What are the encryption mechanisms in sql server?

659


How to write character string constants or literals in ms sql server?

633


What are system databases into sql server (2005/2008)?

665


What guidelines should be followed to help minimize deadlocks?

591