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

How to create a large table with random data for index testing in ms sql server?

532


How to find Duplicate Records In table?

579


How to backup encryption key ?

123


Explain about analysis services?

569


What are different types of statements that are supported by sql?

589






Tell me about builtinadministrator?

558


Tell me about normalization in DBMS.

576


What are the different authentication modes in sql server? How can it be changed?

565


What does ss stand for sexually?

576


What are the restraints imposed on the table design by a merge replication?

562


How can we solve concurrency problems?

564


Do you know what is sql service broker?

530


Which table keeps information about stored procedures?

529


What are the purpose of Normalisation?

635


Is mysql the same as sql server?

503