SSIS is one of the best ETLs
July 16, 2018

SSIS is one of the best ETLs

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

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.

Pros

  • Transform the data
  • Lookups
  • Performance

Cons

  • 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

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

Comments

More Reviews of SSIS

  1. Home
  2. Data Integration Tools
  3. SSIS Reviews
  4. User Review of SSIS