Dataloader.io vs SSIS comparison

"I find DataLoader's ability to easily integrate with external keys valuable, which is a bit more challenging with DBM."

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

"DataLoader is cost-effective since it is free."

"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."

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

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

"SSIS' best feature is SFTP connectivity."

"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 has good data integration and good processes."

"We like that this solution includes a developer edition, free of charge, to allow for training."

"The most valuable feature of SSIS is that it can handle real complex transformations."

"DataLoader has limitations, including constraints with file sizes and transactions."

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

"Dataloader has limitations, including constraints with file sizes and transactions. Additionally, at times it can be slow, and when integrating DBM, we find it more complex than Dataloader."

"SSIS has a difficult learning curve when dealing with complex transformations."

"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."

"Generic processes should be used instead of custom code for each table."

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

"We'd like more integration capabilities."

"This solution needs full support for real-time processing."

"Tuning using this solution requires extensive expertise to improve performance."

"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."

"The product is inexpensive and economical."

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

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

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

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

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

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

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

"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."