SSIS is one of the best ETLs
Anonymous | TrustRadius Reviewer
July 16, 2018

SSIS is one of the best ETLs

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

SQL Server Integration Services is used for the following purposes in my organization.
1. Extract data from the source database and transform it and then load it into a destination database
2. Use this for Balancing between 2 or more different databases
3. Extract the data from relational databases and load into data ware house.

  • Transform the data
  • Lookups
  • Performance
  • Script components are always a problem
  • Cannot debug properly inside of Script component
  • Positive Impact: Faster Performance
  • Negative Impact: Script Task and Script component always hangs up
SQL Server Integration Services is best when we use it with Microsoft SQL server database

SSIS Feature Ratings

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