Diffrence between DTS vs SSIS
Answers were Sorted based on User's Feedback
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 |
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 |
Can we insert data if clustered index is disabled?
List the data types available in mssql?
What are different types of subquery?
What is dbcc updateusage?
what r steps to we need to fallow b4 kill the process?
What is an indice?
Do you know what is blocking?
what is maximum size of temp db?
Get Current System Date Time
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?
What is a rownum?
What is the default sql server instance name?