Saved Bookmarks
| 1. |
How Does Ssis Differ From Dts? |
|
Answer» SSIS is a SUCCESSOR to DTS (Data Transformation Services) and has been completely re-written from scratch to OVERCOME the LIMITATIONS of DTS which was available in SQL SERVER 2000 and earlier versions. A significant improvement is the SEGREGATION of the control/work flow from the data flow and the ability to use a buffer/memory oriented architecture for data flows and transformations which improve performance. SSIS is a successor to DTS (Data Transformation Services) and has been completely re-written from scratch to overcome the limitations of DTS which was available in SQL Server 2000 and earlier versions. A significant improvement is the segregation of the control/work flow from the data flow and the ability to use a buffer/memory oriented architecture for data flows and transformations which improve performance. |
|