There are following differences between DTS and SSIS
Data Transformation Services
|
SQL Server Integration Services
|
Limited Error Handling
|
Complex and powerful Error Handling
|
Message Boxes in ActiveX Scripts
|
Message Boxes in .NET Scripting
|
No Deployment Wizard
|
Interactive Deployment Wizard
|
Limited Set of Transformation
|
Good number of Transformations
|
NO BI functionality
|
Complete BI Integration
|
No comments:
Post a Comment
If you have any doubt, please let me know.