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

What are the triggers in sql?

0 Answers  


Explain database normalization?

0 Answers  


Is port 1433 secure?

0 Answers  


what is unique and xaml nonclustered index

0 Answers  


Why the trigger fires multiple times in single login?

0 Answers  






How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  


DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,


wat new abt truncate in sql server

2 Answers   HCL, HP,


How do you set a trace flag in sql server?

0 Answers  


Which command is used for user defined error messages?

0 Answers  


How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,


What is sql server replication? : sql server replication

0 Answers  


Categories