Dataloader.io vs SSIS comparison

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

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

"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 aspect of this solution is that it is simple to use and it offers a flexible custom script task."

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

"The performance and stability are good."

"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."

"It's a competent product."

"The setup is straightforward. It's very easy to install."

"SSIS' best feature is SFTP connectivity."

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

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

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

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

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

"The performance of SSIS could improve when comparing it to Oracle Database."

"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."

"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."

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

"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."

"The product is inexpensive and economical."

"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."

"People have to opt for a perpetual-based licensing model."

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

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

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

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

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

"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."