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

what is create database syntax? : Sql server database administration

0 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

Explain relational data?

0 Answers  

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

what is the difference between openrowset and openquery?

0 Answers  

---

Explain few of the new features of sql server 2008 management studio

0 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

Explain different types of index?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---