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 to use group functions in the select clause in ms sql server?

536


How to retrieve error messages using mssql_get_last_message()?

532


How to how to convert numeric expression data types using the convert() function??

543


Does the order of columns in update statements matter?

478


What is rolap and its advantage? : sql server analysis services, ssas

644






Explain the ways to controlling cursor behavior?

540


What is single-user mode?

522


What is raid, and how it can influence database performance?

576


Tell me what is the significance of null value and why should we avoid permitting null values?

549


How do I create a stored procedure in sql server?

519


How do I find the sql server version?

518


what information is maintained within the msdb database? : Sql server administration

509


Write SQL queries on Self Join and Inner Join.

611


What are different types of data sources?

494


when would you go for denormalization? : Sql server database administration

484