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.

What is @@error in sql?

1109

---

What is a schema in ms sql server 2005?

1027

---

How to create sub reports?

251

---

How can you find out which stored procedures are recompiling?

953

---

What is a collation?

1134

---

What triggers long term care?

1094

---

How to use clusters?

1019

---

What is the process of normalising?

1049

---

Does group by or order by come first?

1001

---

Is mysql better than sql server?

1111

---

What are views in ms sql server?

1121

---

What is page in sql server?

997

---

Which is faster statement or preparedstatement?

1003

---

What is a benefit of using an after insert trigger over using a before insert trigger?

1034

---

How is sql server used?

1015

---