SSIS is great if when used in the right place
May 23, 2016

SSIS is great if when used in the right place

Waheed Abualrous, MCP, MCTS, MCE | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

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
if you don't have an Sql Server license or are deploying to any OS other than Windows you need to consider a different technology.

SSIS Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
4
Simple transformations
9
Complex transformations
7
Metadata management
4
Business rules and workflow
6
Collaboration
6
Testing and debugging
7
Integration with MDM tools
3