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's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

List few advantages of stored procedure.

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---

---

What is a functions and types in sql server?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

What is transaction server explicit transaction?

0 Answers  

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

What are the different types of stored procedures?

0 Answers  

---

what is the difference between sql query and google query?

10 Answers   TCS,

---