Actian Pervasive Data Integrator [EOL] vs Dataloader.io vs SSIS comparison

"There were no concerns with the stability. This product is very good from a stability perspective."

"he product’s most valuable feature is ease of access."

"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."

"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."

"The initial setup of this solution is very straightforward."

"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."

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

"SSIS' most valuable feature is its reporting services."

"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."

"We need help with large data migrations. It only works well for a few thousand records or less than a million records."

"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."

"The solution could improve on integrating with other types of data sources."

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

"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."

"SSIS has room for improvement, mainly because the overall package can be buggy. It often locks up, requiring a restart, which is annoying. However, since it's free, we tolerate these performance issues. I'd like to see better debugging tools in future releases and improvements in API calls; It would be helpful if SSIS had a built-in API engine so we wouldn't have to rely solely on database connections."

"We've had issues in terms of the amount of data that is transferred when we are scheduling."

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

"We'd like more integration capabilities."

"The product is inexpensive and economical."

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

"This solution is included with the MSSQL server package."

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

"The solution comes free of cost."

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

"We have an enterprise license for this solution."

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

"The solution is available at a lesser price than that of Informatica."