- Highest Rating
- Lowest Rating
- Review Length
Showingreviews based on the current filters.
Oct 06 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 free utility rather than as an enterprise ETL tool. Which is ironic given it is superior to many of the supposed enterprise-class tools in a number of areas. The lack of respect in our industry is likely due to immature beginnings in its former "DTS" days and because it comes bundled "free" with Sql Server. 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 years and I'll take SSIS over any of them. I've now used SSIS exclusively for close to a decade and have no regrets. 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 »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,517 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 »
May 26 2020
What is most valuable?Script task and Script component for custom tasks: It gives you power to build your own logic if your requirements are not being fulfilled with existing available components. While the big thing is you can build your own components, that is not so straightforward. It's visual design interface is… more »
How has it helped my organization?SSIS is a tool which anybody can learn in no time. When we started the project, the whole team learnt it in one week's time and then were ready to start on project tasks. It gives you control.
What needs improvement?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. We couldn't explore big data related components, and this area should be up to the mark, if not… more »
What other advice do I have?Overall, we remained in a good position and in control while using SSIS. We didn't face any challenges.
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.
See 12 More SSIS Reviews
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
Download our free SSIS Report and get advice and tips from experienced pros sharing their opinions.
- Which ETL tool would you recommend to populate data from OLTP to OLAP?
- What is the biggest difference between SSIS and Pentaho?
- What are the pros and cons of SSIS?
- When evaluating Data Integration, what aspect do you think is the most important to look for?
- Does anybody have experience using a Matrix Template Library for high-performance applications in finance?