What is our primary use case?
Movement of data and creation of files. ALl the typical things that you would have a ETL solution do. Data movements were in the millions and no calculations were completed. This means it was always a select * from where ever it was coming from and going to. Light translations like concatenation was being used.
How has it helped my organization?
SSIS was easily adaptable to our group. It was cheaper than the other tools that we compared it to, however I feel that we got what we paid for.
What is most valuable?
The packaging and how it is organized is good for someone that really has never seen ETL before.
What needs improvement?
Scalability of SSIS needs some improvement. Seems to get sluggish as soon as we hit a high volume of data.
For how long have I used the solution?
What do I think about the stability of the solution?
Again it failed a lot and by a lot I mean every day. The failures were false alarms and caused many sleepless night for our company that I used to work for.
What do I think about the scalability of the solution?
SSIS is good for smaller shops that don't really have a high volume of data.
How are customer service and technical support?
I would rate the customer service as poor.
If you previously used a different solution, which one did you use and why did you switch?
We were using Hyperion Application Link. We switched because HAL was being sunset.
How was the initial setup?
Never participated in the initial setup.
What about the implementation team?
What was our ROI?
For the money, it's a decent tool. However, if the budget was larger I would have gone with a different tool
What's my experience with pricing, setup cost, and licensing?
Look at how this product is sold to you. Ask yourself, am I getting everything that I need. Its more expensive to get the additional adapters after the fact.
Which other solutions did I evaluate?
We looked at ODI, Informatica, and DataStage. All three we had in-house. ODI was the better option and after dealing with SSIS for only a few months, we ended up using ODI.
Disclosure: I am a real user, and this review is based on my own experience and opinions.