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."
"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."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"It has good data integration and good processes."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"SSIS' best feature is SFTP connectivity."
"It's saved time using visualization descriptions."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"We need help with large data migrations. It only works well for a few thousand records or less than a million records."
"Microsoft should offer an on-premises support warranty for those using that deployment. They seem to be withdrawing from on-premises options."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"It needs more integration tools, so you can connect to different sources."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"Future releases should improve the data lineage, as it currently is not good."
"I would like to see more features in terms of the integration with Azure Data Factory."
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.