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.

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

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  

---