SQL Server Integration Services
December 09, 2025
SQL Server Integration Services
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
In my organization, I use SQL Server Integration Services to automate data flow into different systems used by different departments. I create reports of our daily/weekly data for the upper management to review. Those reports are made with the help of SQL Server Integration Services. I fetch all the data for the report using SQL Server Integration Services. The reports are generated automatically now, I just have to send it to the upper management.
Pros
- SQL Server Integration Services helps in fetching the data from our cloud Genesys application to create/generate reports. The reports are on point with accurate data. It is so efficient and time saving for me.
- We use SQL Server Integration Services to keep the employee data records updated. It automatically enters all the employee data such as recent pay slips, recent performance reviews everything to the appropriate entry. Manual work has been very less since we started using SQL Server Integration Services.
- We also collect IT data using SQL Server Integration Services. It gets us detailed data of our systems which would so if there are any technical issues/glitches in the system. We can easily use that to resolve the issue rather than wasting time on manually searching where the issues started and what is causing the technical issue.
Cons
- I think the response time of real time data is very slow. It is difficult to use SQL Server Integration Services in a fast faced environment where we have to work on lot of real time data.
- SQL Server Integration Services issues are very hard to resolve. If there is a technical issue, the errors are not worded properly, It doesn't give a straight forward issue. They are very generic and it takes a lot of time to find what the error is and to fix it.
- Time efficiency is the biggest positive impact, I think. It helps with large complex data. It saves a lot of time. Generating reports are super easy with it.
- Data efficiency - The data is also accurate. There are hardly any errors in the data.
- Negative impact - Doesn't work well with real time data.
- Its technical issues are very complex, it takes lot of time to find the problem, fix it and making sure that the entire system is working well.
Both are very similar. Azure is cloud based. It is easier for the organization who uses cloud based application. The SQL Server Integration Services is cost effective. Azure was more on the expensive side for our organization. Azure was a little complex, it needed special training to use it. Azure was not accurate with complex data.
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?
Yes
Would you buy SQL Server Integration Services again?
Yes
Comments
Please log in to join the conversation