Answer Posted / 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.

Can group by and orderby be used together?

1019

---

List out the differences between global and local temp tables in sql server?

1068

---

Define magic tables in sql server?

1071

---

Which table keeps the locking information?

932

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1895

---

What are the 10 characteristics of data quality?

957

---

Define Joins?

1036

---

What is a result set object returned by odbc_exec()?

1034

---

What is sql stored procedure?

1100

---

whats new about truncate in sql server 2008?

2508

---

Explain about the command-line tool SQLCMD?

1096

---

What is the datatype of rowid?

929

---

What is a print index?

892

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2003

---

How to send a ssrs report from ssis?

177

---