SQL Server Integration Services - still kicking after all these years
August 11, 2025

SQL Server Integration Services - still kicking after all these years

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

Overall Satisfaction with SQL Server Integration Services

Data Engineering and integration. Move data between different on-premise servers no matter the platform. Since we have an Enterprise Agreement with Microsoft, it does not cost any extra to use SQL Server Integration Services unlike Azure Data Factory or Informatica. Wherever data transfer is involved, it is the de-facto standard in our company.

Pros

  • Easily connects to source and destination systems
  • GUI interface - so minimal learning curve
  • Script task feature enables extensibility and access to .NET framework

Cons

  • Zero enhancements by Microsoft in a very long time
  • Has fewer connectors compared to Power BI or ADF
  • Not ideal for handling huge datasets
  • Saved tons of money over the years by not having to go out and buy another licensed product. Since we have been using it for 15 years, that would be approximately 15 times $25K
  • Saved a lot of development hours due to the minimal learning curve, even our interns are able to use it thereby freeing time for higher skilled employees to work on more complex problems
  • A big user community helps speed up trouble-shooting and support
Very user friendly interface, however the GUI has has zero improvements for a very long time. So, it has not kept up with similar tools and suffers in comparison.
I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer

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?

I wasn't involved with the selection/purchase process

Did implementation of SQL Server Integration Services go as expected?

I wasn't involved with the implementation phase

Would you buy SQL Server Integration Services again?

Yes

Ideal if the company is already a Microsoft shop, so chances are that it is free with SQL Server. Also, good for moving data between on premise systems.

Not ideal for moving data to the cloud. No functionality out of the box to work with REST APIs. Stable product but definitely not the future

SSIS Feature Ratings

6.0
Connect to traditional data sources
8
Connecto to Big Data and NoSQL
4
7.0
Simple transformations
10
Complex transformations
4
6.3
Business rules and workflow
5
Collaboration
8
Testing and debugging
6
3.0
Integration with data quality tools
3
Integration with MDM tools
3

Comments

More Reviews of SSIS

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