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

Explain database normalization?

0 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

What are distinctive joins find as a part of sql?

0 Answers  

---

How to install sql server 2005 express edition?

0 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

Explain how to integrate the ssrs reports in application?

0 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What is for xml in sql server?

0 Answers  

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

What is 1nf normalization form?

0 Answers  

---