How to work on DTS?what is the main requirement?



How to work on DTS?what is the main requirement?..

Answer / naresh

DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How do you set a trace flag in sql server?

0 Answers  


Describe the left outer join & right outer join. : sql server database administration

0 Answers  


What is service broker? : sql server database administration

0 Answers  


Does partitioning ssd reduce performance?

0 Answers  


What is a transact-sql statement batch in ms sql server?

0 Answers  






What you can do to delete a table without the delete trigger firing?

0 Answers  


What are the indexes in sql server?

0 Answers  


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

0 Answers  


i need some interview questions on sql server developer plz any onee send some links.

2 Answers  


What is normalization?

9 Answers  


Can binary strings be used in arithmetical operations?

0 Answers  


What is sql server locking?

0 Answers  


Categories