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 used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"It's already very user-friendly and has a good dashboard."
"It's saved time using visualization descriptions."
"The initial setup was easy."
"The setup is straightforward. It's very easy to install."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"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 debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"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."
"The high prices attached to the product can be an area of concern where improvements are required."
"The solution could improve on integrating with other types of data sources."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"Options for scaling could be improved."
"The performance of SSIS could improve when comparing it to Oracle Database."
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 BMC Data Management for IMS and DB2 on zOS, DBamp and Mule Anypoint Platform, 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.