We performed a comparison between Dataloader.io and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."he product’s most valuable feature is ease of access."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"SSIS is easy to use."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"The initial setup was easy."
"The scalability of SSIS is good."
"SSIS' best feature is SFTP connectivity."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"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."
"It hangs a lot of the time."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"Generic processes should be used instead of custom code for each table."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"Future releases should improve the data lineage, as it currently is not good."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
Dataloader.io is ranked 39th in Data Integration with 1 review while SSIS is ranked 2nd in Data Integration with 69 reviews. Dataloader.io is rated 8.0, while SSIS is rated 7.6. The top reviewer of Dataloader.io writes "Provides an ease of access and an automated mapping feature". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Dataloader.io is most compared with DBamp, Mule Anypoint Platform and BMC Data Management for IMS and DB2 on zOS, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.