- Highest Rating
- Lowest Rating
- Review Length
Feb 10 2020
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. Which is ironic given it beats out many of the supposed enterprise-class tools in areas such as logging, application adapters and parameter support. The lack of respect in our industry seems due to immature beginnings in its former "DTS" days and because it comes bundled "free" with Sql Server installation. But don't let that fool you into thinking it can't compete with the expensive ETL tools. I've used many ETL tools over the past two decades and I'll take SSIS over any of them. SSIS is extremely flexible,…
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»
Which solution did I use previously and why did I 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: February 2020.
398,890 professionals have used our research since 2012.
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»
Which solution did I use previously and why did I 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.
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»
Which solution did I use previously and why did I 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.
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.
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»
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»
Which solution did I use previously and why did I 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.
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.
Which solution did I use previously and why did I 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 12 More SSIS Reviews
User Assessments By Topic About SSIS
Read Archived Reviews
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 asSQL Server Integration Services
SSIS customersPKP Energetyka, UniCredit Bank, Mostar, waldwasser, Ashok leyland, Florida Atlantic University, Stadt Frankfurt am Main