SSIS vs Upsolver comparison

"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."

"The script component is very powerful, things that you cannot normally do, is feasible through C#."

"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."

"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."

"The simplicity of the solution is great. The solution also offers excellent integration."

"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 technical support is very good."

"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."

"Customer service is excellent, and I would rate it between eight point five to nine out of ten."

"It was easy to use and set up, with a nearly no-code interface that relied mostly on drag-and-drop functionality."

"The most prominent feature of Upsolver is its function as an ETL tool, allowing data to be moved across platforms and different data technologies."

"The performance of SSIS could improve when comparing it to Oracle Database."

"I would like to see more features in terms of the integration with Azure Data Factory."

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."

"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."

"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

"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."

"Upsolver excels in ETL and data aggregation, while ThoughtSpot is strong in natural language processing for querying datasets. Combining these tools can be very effective: Upsolver handles aggregation and ETL, and ThoughtSpot allows for natural language queries. There’s potential for highlighting these integrations in the future."

"On the stability side, I would rate it seven out of ten. Using multiple cloud providers and data engineering technologies creates complexity, and managing different plugins is not always easy, but they are working on it."

"There is room for improvement in query tuning."

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

"t's incredibly cost effective, easy to learn the basics quickly (although like all ETL tools requires the traditional learning curve to get good at) and has an immense user base."

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

"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."

"I'm not involved in licensing details, but SSIS provides value to our organization by simplifying data management tasks."

"We purchased the standard edition of SQL Server and SSIS came with it free of charge."

"Our license with SSIS is annual."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"Upsolver is affordable at approximately $225 per terabyte per year."