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

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What is the parse query button used for?

0 Answers  

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

What is create statement?

0 Answers  

---

---

What are the triggers in sql?

0 Answers  

---

what is the difference between openrowset and openquery?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

Do you know what are the reporting services components?

0 Answers  

---

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

---

Explain rdbms?

0 Answers  

---