SSIS Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
GaryM
Real User
Data Architect at a non-profit with 1,001-5,000 employees
Sep 05 2019

What do you think of SSIS?

Sql Server Integration Services (SSIS) 2016 Review Summary SSIS 2016 - the Good the Bad, and the Ugly SSIS is a unique ETL tool for a number of reasons. Most shops already own it but may treat it as a one-off free utility rather than as an enterprise ETL tool even though it can compete with the best of ETL tools. The lack of respect is primarily due to immature beginnings in its former "DTS" days. And some of it is because it comes bundled "free" with Sql Server and does not normally run (but can) on a separate server.  It can't be good if its free right?  Especially when competitors easily charge 6 figures for  their tools. Don't we get what we pay for?  My answer is, generally yes but this is a really big exception. SSIS has become extremely flexible, extensible and…
SeniorBI67
Real User
Senior BI Developer at a music company with 501-1,000 employees
Jul 31 2019

What is most valuable?

We use everything in this solution, including a third party component called COZYROC. We try to explore and use this product to its fullest.

How has it helped my organization?

This solution allows us to be repeatable in the sense of how we move data from A to B. It is easily scheduled and integrates well with SQL Server and SQL Server Agent… more»

What needs improvement?

The login process needs improvement. At the moment, when you run SSIS and it's logging on SysTD within the server itself, I think that you have the option to do verbose… more»

What's my experience with pricing, setup cost, and licensing?

When you purchase SQL Server, SSIS tends to come with it. Whether you purchase the standard edition or an enterprise edition, SSIS comes with it. Whether you choose to… more»

If you previously used a different solution, which one did you use and why did you switch?

Prior to this solution, before 2005, we used DTS.

What other advice do I have?

My advice for anybody who is considering this solution is to install the trial version first. You can get the SQL development edition, which pretty much has everything the… more»

Which other solutions did I evaluate?

We did not evaluate other products before choosing this solution. However, in the last couple of years, I have researched a few others. One of these solutions looks good… more»
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: October 2019.
372,374 professionals have used our research since 2012.
Real User
Data Scientist at a tech vendor with 501-1,000 employees
Jul 31 2019

What is most valuable?

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

What needs improvement?

The synchronous processing needs to be improved. For batch processing, it works fine, but when you start to do real-time processing, I find that this solution is not strong, depending on how you use it. If you use it for short batches… more»

If you previously used a different solution, which one did you use and why did you switch?

For the most part, we started with this solution.

What other advice do I have?

My advice to anybody implementing this solution is to look into whether to use it on a catalog in a database, versus using package deployment. There are pros and cons to both approaches in terms of deployment and security. I would say… more»

Which other solutions did I evaluate?

This solution was already in place. That's what is available and it's what people know. Going forward, this will most likely change.
AhmedShaban
Reseller
Database Consultant
Aug 05 2019

What is most valuable?

I like that the data connections and all ODB connections are able to retrieve data from so many different databases. That's not only from SQL but also from other data sources as well. The data flow, which controls the data, including where… more»

What needs improvement?

More coding is needed to make it easier. It needs more development and enhancement. It also needs to offer different integration services for SQL. We had to do a lot fo the implementation ourselves, but more automating of the processes… more»

If you previously used a different solution, which one did you use and why did you switch?

Previously, we used the .NET framework, which we are still using as well.

What other advice do I have?

In terms of advice I would give in regard to implementing this product, I'd say to examine your business needs in relation to the solution. You need to make sure those are met before implementing it. A lot of companies use data filers and… more»

Which other solutions did I evaluate?

As a teacher, I worked with SSIS, so I previously used this solution. I didn't look at other options.
Alireza Nikseresht
Real User
CEO at Shiraz University
Jul 21 2019

What is most valuable?

Usually, when I want to import data from other databases I use this solution. It's been about fifteen years that I've worked with an SQL server, and I'm a software developer. I've had many companies… more»

How has it helped my organization?

This product is always used in projects because I'm in a company that develops software for other companies and we accept this type of work like programming and developing data models and writing the… more»

What needs improvement?

Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but… more»

What's my experience with pricing, setup cost, and licensing?

The price is important to us. We are based in Iran, and we look for products with a good price because of the sanctions. Some other products such as Oracle are expensive here and we do not recommend… more»

What other advice do I have?

We chose the solution because we have some data in Oracle and we wanted to extract it and load the data into SQL Server. The type of port, like SSIS, I always recommend other companies to use it and… more»

Which other solutions did I evaluate?

I used this product when I was a student so I chose this technology because I understood it best.
Globalmark677
Real User
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
Aug 01 2019

What is most valuable?

Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture. The interface is also very good. If users are familiar with Microsoft, then they'll be quite familiar with the interface.

What needs improvement?

We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage. As… more»

What other advice do I have?

We're using the on-premises version of the solution. My only recommendation to those considering implementation of the solution would be, if they want to check data lineage, they should set up the packages with a particular configuration that they would have to follow in order to get data lineage. If they were to start it from scratch, my recommendation would be just to follow the pattern to… more»
Real User
Founding Partner at Altdata Analytics
Aug 06 2019

What is most valuable?

With this solution, there is the potential to expand so that you can immediately write code onto the SQL server. Auto-parallelization is also critical for us. It decides automatically how many parallel sessions you have to run to get your query handled. You don't need to take care of any code, which… more»

What needs improvement?

The solution should work on the GPU, graphical processing unit. There should also be a piping integration available. The design of the dashboard isn't great, visually, but the solution works, so this isn't so important to me. SSIS's competitor, Autonomous Database by Oracle, offers you, depending on… more»

If you previously used a different solution, which one did you use and why did you switch?

We previously used Oracle as an integration tool, but it's much more expensive than Microsoft.

What other advice do I have?

I use the private cloud as well as the on-premises version of the solution. I would rate this solution eight out of ten. I would rate it higher if the solution offered full automation AI for database managing, setup and management, and scaling of the solution.
Sherif Abdelrehim
Real User
Data Architect and Modeler at a tech services company with 201-500 employees
Aug 22 2019

What needs improvement?

My team is facing problems regarding the database connectors, which are not available. The MySQL connectors need to be purchased from outside vendors. They should provide connections for more SQL databases, free of charge. The performance of this solution is not as good as other tools in the market. Compared to the same job is running in a different tool, it will take longer using SSIS.

If you previously used a different solution, which one did you use and why did you switch?

In my previous company, I was leading a team who were working with Informatica. Here, they stick to Microsoft technologies and are unwilling to change.

What other advice do I have?

The decision to use this particular solution includes many factors. Some companies do not want to purchase a license for another product because this one comes included with the database. SSIS worked well for small or medium-sized Projects. For larger projects with huge data, I believe that you should search for another solution as you will need to do manual fine tuning. Additionally, some… more»
See 11 More SSIS Reviews

Articles

User Assessments By Topic About SSIS

Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: October 2019.
372,374 professionals have used our research since 2012.

SSIS Questions

What is SSIS?

SSIS is a package is an organized collection of connections, control flow elements, data flow elements, event handlers, variables, parameters, and configurations, that you assemble using either the graphical design tools that SQL Server Integration Services provides, or build programmatically. You then save the completed package to SQL Server, the SSIS Package Store, or the file system, or you can deploy the ssISnoversion project to the SSIS server. The package is the unit of work that is retrieved, executed, and saved.
Also known as
SQL Server Integration Services
SSIS customers
PKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main
Read Archived Reviews
BUYER'S GUIDE
Download our free Data Integration Tools Report and find out what your peers are saying about Microsoft, Informatica, Oracle, and more!
Sign Up with Email