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

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

How to attach adventureworkslt physical files to the server?

0 Answers  

---

List out the different types of locks available in sql server?

0 Answers  

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

How to restore performance issues and how to check?

0 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---