Infogix Data360 Analyze [EOL] vs SSIS comparison

"The drag-and-drop functionality makes it easy for business users."

"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."

"The setup was easy. All Microsoft products are easy to set up."

"The setup is easy to use and understand."

"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."

"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."

"The simplicity of the solution is great. The solution also offers excellent integration."

"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."

"SSIS is easy to use."

"The memory processing needs to be improved because when you deal with a large amount of data, the interface tends to hang a little bit."

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

"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."

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

"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."

"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."

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

"SSIS is stable, but extensive ETL data processing can have some performance issues."

"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 open-source version is free to use, although it has a limitation of two-million records."

"We have an enterprise license for this solution."

"The solution is available at a lesser price than that of Informatica."

"The solution comes free of cost."

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

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

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

"Our license with SSIS is annual."

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