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

Why use triggers?

780


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

915


Are resultset updatable?

704


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

662


How to connect to a sql server using odbc_connect()?

838


Where in ms sql server is ’100’ equal to ‘0’?

800


What is the difference between SQL notification and SQL invalidation?

786


What is the difference between truncate and delete commands?

742


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1675


How do I view a procedure in sql server?

751


List the various tools available for performance tuning?

641


What are the functions in sql server?

712


Where cross join is used?

690


How can you find out how many rows returned in a cursor?

759


What is left outer join in sql server joins?

697