Data processing with SSIS
June 23, 2022

Data processing with SSIS

John Ramírez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with SQL Server Integration Services

Being part of the Healthcare department, we need to automate the data transfer from and to the company and hospitals. SQL Server Integration Services, allowed us, to create a robust platform, to process millions of records from each hospital everyday, the whole year, just taking care of small incidents, such formats, not related to the SSIS, itself. So, we relied on this process for keeping the data and the collection, working efficiently and providing outstanding service.
  • Data transfer
  • Automation
  • Programability
  • Scheduling
  • Clarity on errors
  • Support
  • Helped to increase revenue for the clients
  • Saved big time and work
  • Increased productivity

Do you think SQL Server Integration Services delivers good value for the price?

Yes

Are you happy with SQL Server Integration Services's feature set?

Yes

Did SQL Server Integration Services live up to sales and marketing promises?

Yes

Did implementation of SQL Server Integration Services go as expected?

Yes

Would you buy SQL Server Integration Services again?

Yes

Automation for data transfer, where you don't need to be moving or copying any data manually.
Processing data, for ETL, so you can just get the files, using something like FTPs automation and the data will be processed, and then you can just work on your reports or do all the BI needed for the company

SSIS Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
10
Complex transformations
9
Data model creation
9
Metadata management
9
Business rules and workflow
9
Collaboration
10
Testing and debugging
8
feature 1
Not Rated
Integration with data quality tools
9
Integration with MDM tools
9