Overall Satisfaction with SQL Server Integration Services
Ee create master data management and workflow software for oil and gas companies which involves getting and writing data to other systems. We use SSIS for all integration as it helps dealing with different systems.
- Makes it very easy to move data form one system to another
- So many out of the box transformations
- The script task gives you so much flexibility as you can write C# code to do almost anything
- Easy deployment and configuration after the 2012 release
- Project deployment model to allow deployment of single packages
- Allowing to apply one transformation on all columns, like changing all column types from nvarchar to varchar instead of doing it one by one
- Mamed parameters from inline SQL statments using OLEDB command, currently they are called parameter 1, parameter 2...etc., which is confusing when you have many paramters
- Pass authorization tokens when calling remote processes like a console application, currently being called as anonymous
- Comes free with SQL server so no additional license
- Easy to learn and material is available for free, no need for expensive training