FME vs SSIS comparison

"All spatial features are unrivaled, and the possibility to execute them based on a scheduled trigger, manual, e-mail, Websocket, tweet, file/directory change or virtually any trigger is most valuable."

"The most valuable feature of FME is the graphical user interface. There is nothing better. It is very easy to debug because you can see all steps where there are failures. Overall the software is easy to optimize a process."

"It has a very friendly user interface. You don't need to use a lot of code. For us that's the most important aspect about it. Also, it has a lot of connectors and few forms. It has a strong facial aspect. It can do a lot of facial analysis."

"We make minor subtle changes to the workbenches to improve it. We can share the workbenches. We don't have to use GitHub or anything else."

"It has standard plug-ins available for different data sources."

"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."

"The setup was easy. All Microsoft products are easy to set up."

"The scalability of SSIS is good."

"I like that this solution is very scalable, accommodating large datasets and various types of servers. It integrates with most common database servers and allows for customization through coding, including complex scripts. Compared to Alteryx Designer, SSIS offers more customization. Its data cleaning capabilities are highly accurate because we can run tests as data is loaded, ensuring it meets all requirements before reaching the final destination. The ability to write custom SQL and C# code within SSIS packages is its greatest feature."

"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."

"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"To get a higher rating, it would have to improve the price and the associated scalability. These are the main issues."

"The one thing that always appears in the community is the ability to make really easy loops to loop through data efficiently. That needs to be added at some point."

"FME's price needs improvement for the African market."

"FME can improve the geographical transformation. I've had some problems with the geographical transformations, but it's probably mostly because I'm not the most skilled geographer in-house. The solution requires some in-depth knowledge to perform some functions."

"Improvements could be made to mapping presentations."

"Improving the login procedure would make our reporting easier on monitoring our ETL processes."

"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."

"This solution needs full support for real-time processing."

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

"We'd like more integration capabilities."

"Improvement as per customer requirements."

"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."

"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."

"FME Server used to cost £10,000; now it can cost over £100,000."

"We used the standard licensing for our use of FME. The cost was approximately €15,000 annually. We always welcome less expensive solutions, if the solution could be less expensive it would be helpful."

"The product's price is reasonable."

"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."

"We have an enterprise license for this solution."

"It would be beneficial if the solution had a less costly cloud offering."

"The solution is economical. You don't have to worry about the pricing as long as you're installing both services on the same server."

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."

"SSIS is fairly well-priced - I would rate it at four out of five."

"This solution has provided an inexpensive tool, and it is easy to find experienced developers."

"All of my clients have this product included as part of their Microsoft license."