what is Data Transformation Services (DTS) ?can u explain
me in detail?

Answer Posted / namz

DTS (Data Transformation Services) comes under Integration
Service.DTS Import and export wizard lets us to import and
export from external data source
DTS has two major components:
1.DTP Data Transformation Pipeline
2.DTR Data Transformation Runtime

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define self join in sql server joins?

514


Why functions are used in sql server?

502


what is a traditional network library for sql servers? : Sql server database administration

460


Does sql server use java?

512


Explain steps of normalization?

521






What are “lock” hints?

585


Explain the Ways to improve the performance of a sql azure database?

64


Explain difference between cross join and full outer join?

554


How to provide default values to stored procedure parameters?

568


Where are stored procedures in sql server?

558


Explain in details security in SQL azure?

97


What stored by the master?

537


what is database replicaion? : Sql server database administration

600


Does any body please help me what question's have asked for SSRS in the interview?

1662


How to connect Azure federated root database and apply federation in entity framework?

87