Diffrence between DTS vs SSIS

Answers were Sorted based on User's Feedback



Diffrence between DTS vs SSIS..

Answer / venkat

DTS: 1)it is a part of db engine service. only 32 bit architecture is supported.
2) DTS packages--->DTS wizard, DTS designer.
3) VB script is supported.

SSIS:1)SSIS is a service independent from db engine service.
2) It supports 32 and 64 bit architecture.
3) SSIS-----> SSIS wizard, SSIS designer
4) VB and c#.net is supported.

Is This Answer Correct ?    5 Yes 1 No

Diffrence between DTS vs SSIS..

Answer / shyamsri83

DTS-Data Trasformation Services available up to SQL Server
2000
SSIS - Sql server integration services. available from sql
server 2005. SSIS is introduced instead of DTS

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can we insert data if clustered index is disabled?

0 Answers  


List the data types available in mssql?

0 Answers  


What are different types of subquery?

0 Answers  


What is dbcc updateusage?

0 Answers  


what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,


What is an indice?

0 Answers  


Do you know what is blocking?

0 Answers  


what is maximum size of temp db?

4 Answers   iSoft,


Get Current System Date Time

2 Answers  


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,


What is a rownum?

0 Answers  


What is the default sql server instance name?

0 Answers  


Categories