Answer Posted / maddy

Hi,
The DTS and SSIS are both used in SQL Server
Transformations. Th e DTS was used for transformation
purpose upto SQL Server 2000 and SSIS (Including SSAS and
SSRS) are the advanced to DTS and are included in SQL Server
2005 onwards. The capability of SSIS tool in comparison with
DTS is tremendous. This SSIS tool is in competition with
other ETL Tools in the present.The SSIS has lot added
features as per the current requirements.

Explain the microsoft sql server delete command? : SQL Server Architecture

1086

---

How data can be copied from one table to another table?

950

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1191

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

966

---

Explain primary key, foreign key and unique key?

994

---

What types of replication are supported in sql server?

1063

---

How to define the name and server for a new dsn?

1120

---

According to you what goes into making the best database administrator? : sql server database administration

978

---

How to use the inserted and deleted pseudo tables?

961

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

901

---

What is the definition for sql server 2000?

1090

---

What have included columns when we talk about sql server indexing?

1037

---

Why the trigger fires multiple times in single login?

1213

---

How do I schedule a sql server profiler trace?

981

---

how would you store your query in an SSRS report or a Database server?

162

---