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

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

What is a group function explain with an example?

0 Answers  

---

What are information schema views?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

Is null in sql server?

0 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

What is 1nf 2nf and 3nf?

0 Answers  

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

---

How can we delete a table in sql server?

0 Answers  

---