Provides value to cost and excellent with MSBI Stack, But needs more features/updates
December 08, 2021

Provides value to cost and excellent with MSBI Stack, But needs more features/updates

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

Overall Satisfaction with SQL Server Integration Services

SQL Server Integration Services has been useful in implementing Extract, Load, and transform logic from various sources and destinations. we also use it to download data files from SFTP, FTP locations. We use it to refresh extract in tableau and run other 3rd party services via executing process tasks. It has been useful to address many other such challenges.
  • FTP Downloads.
  • Run 3rd party softwares.
  • Intuitive UI.
  • Need more connectors/sources/destination components.
  • Ability to support not just Microsoft services but others too.
  • More updates & new features.
  • Faster loads.
  • Cheaper alternative but more development & compromise on performance.
  • Support with cloud tech other than Microsoft.
SQL Server Integration Services is a good alternative to cut down on costs and have more flexibility on developing.

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

More suited for Full loads, use along with other Microsoft services, ETLs Less suited for: use along with modern software/services, Near real-time integration.

SSIS Feature Ratings

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