5 out of 5.0, Reviewed Jun 23, 2016
We have implemented an enterprise-wide solution for jobs to integrated data across multiple platforms but mainly SQL Server databases. It was smooth and flawless and we were able to integrate the necessary security to make this an enterprise solution.
I like the fact that it is from Microsoft which we already have implemented many of their other products and it works seamlessly with SQL Server.
SSIS has been able to handle every data integration need that we have.
We implemented this all internally. So we didn't need to consult them, but in the past we've gotten excellent service and support from Microsoft.
Excellent integration abilities and easy deployment.
3 out of 5.0, Reviewed Dec 1, 2015
I believe there are still a few areas where Microsoft can work to improve the product. In particular the web service integration is very limited and requires extensive scripting to compensate for it.
Its a fairly simple tool to use but some relatively simple tasks may require more work than at first expected.
Fairly easy to use especially for simpler tasks.
Needs more transformations for web based tasks
They should definitely put more work into web service implementations (handling complex data types, etc.)
We would still implement using this technology as the other alternatives which were explored were far more complex and required dedicated programming skills.
There are a few issues with web integration but can be overcome with scripting.
Our current contract allows us a minimum level service each year.
Deployment was a breeze.
3 out of 5.0, Reviewed Aug 12, 2015
Microsoft didn't engage in a way that was satisfactory when we had questions and/or problems with the product.
Make sure you talk to other companies/people that are using this product and ask them how many people they have on staff to support it.
It is slowly loosing market share and therefore is harder and harder to find resources.
Had experts on their staff to assist rather than depending on 3rd party vendors.
We would do a better job at a software selection process to find a product that fits our needs better and doesn't require so much development effort.
Capabilities met our needs but hard to determine if they will be able to keep up with the market
We had an incident opened with MS on a problem we were having connecting to the AS/400. It required MS to develop a fix. When they were in the process of developing that fix, we were not kept in the loop. When it finally was created and given to us, it didn't resolve our issue.
Setup and deployment took a long time because it was so new. Even MS didn't have full documentation on how to setup a high availability environment, we had to figure out most of it.
4 out of 5.0, Reviewed Jun 17, 2015
We were pleased with the outcome
It just works
3 out of 5.0, Reviewed Apr 2, 2015
Good tracking capabilities and data processing.
Look more on complexity.
Good integration tool.
Was effective as integration and reliability.
3 out of 5.0, Reviewed Apr 2, 2015
It's a cost effective tool.
Good support and service.
It's not the best of the products but gets work done.
4 out of 5.0, Reviewed Apr 2, 2015
Microsoft SQL Server Integration Services is a great fit for our SQL Server environment. The product has come a long way from the version in 2005. The logging and deployment is much better. There is still a learning curve with integration developers who are used to creating manual batch, BCP, and SQL Scripts.
Look for an integration framework that can make the adoption of any tool a little less daunting.
The cost is bundled with the DBMS.
It requires developers. This is not an end user tool.
Start with more executive sponsorship. Get developer training faster.
This does everything we need it to do for now. It's a good entry to integration tools.
Hosting packages inside SQL helps speed deployment.
4 out of 5.0, Reviewed Mar 31, 2015
Overall our experience with Microsoft has been good but they do have a tendency to shift focus frequently and unexpectedly.
Work closely with your TAM to get the resources you need to architect the system for growth.
Cost is a huge factor for us, resources are plentiful and relatively inexpensive.
Licensing model and ease of use can be issues.
Clarify their licensing model. There are too many options.
We would probably pay closer attention to the scalability of the solution. We painted ourselves into a bit of a corner with the sizing of our equipment.
MS support is not the best I have seen, but we have rare occasion to use it.
Planning is key, particularly for scalability and growth.