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

Answer Posted / virendra

It is builtin facility of Sql Server provovided by
microsoft for import and export
database/table/structure/database objects from one database
package/ server to other/differnet.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does Report Builder support Analysis Services cubes?

120


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

576


Should you normalize audio?

623


Explain Reporting Life Cycle?

94


What is 'Join' and explain its various types.

712






what is the difference between count(*) and count(1) ?

710


What is the difference between left and right outer join?

618


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

626


How to delete a database in ms sql server?

640


What is clustered vs nonclustered index?

590


What is the use of tempdb? What values does it hold?

646


What is normalization process?

680


What do you understand by recursive stored procedure?

593


What to perform pattern match with the like operator?

564


What is multi-statement table-value user-defined function?

610