Monday 22 December 2014

What are the differences between DTS and SSIS

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.

Popular Posts