2019-07-18T11:31:00Z

What advice do you have for others considering SSIS?


If you were talking to someone whose organization is considering SSIS, what would you say?

How would you rate it and why? Any other tips or advice?

Guest
1515 Answers

author avatar
Top 5Real User

Overall, we remained in a good position and in control while using SSIS. We didn't face any challenges.

2020-05-22T08:08:00Z
author avatar
Real User

I would rate it a seven out of ten. Not a ten because of the data extraction that crashed. Tableau is better in this aspect. The transformation of data is very good in SSIS.

2019-08-04T07:38:00Z
author avatar
Top 5Real User

I would recommend the solution. It's always worked for me and it's usually a top choice for my clients. I would rate this solution at seven or eight out of ten. It's not a perfect solution, but it works well.

2019-07-31T05:52:00Z
author avatar
Top 20Reseller

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 they already have existing databases. You need to make sure the solution you choose is able to deal with old databases of client records. I would rate this solution ten out of ten.

2019-07-31T05:52:00Z
author avatar
Top 20Consultant

If you have data needs and you are a small or medium enterprise this is a good solution. If you are an organization and you're not dealing with terabytes of data, but you still need to analyze data to make that decision, you should go with this solution. I would rate it a 7.5 out of ten.

2019-07-31T05:52:00Z
author avatar
Real User

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 components such as SCD will show unexpected errors with huge data. As Microsoft is very slow in providing updates and enhancements to SSIS, I see that the future for Integration projects in Saudi Arabia goes towards other vendors products such as Informatica powercenter, IBM DataStage, and Oracle ODI. Compared to other Integration tools, I would rate it a six out of ten.

2019-07-31T05:52:00Z
author avatar
Top 20Real User

We use the on-premises version of the solution. I would recommend the solution to others. I'd give it a rating of eight out of ten.

2019-07-31T05:52:00Z
author avatar
Top 5LeaderboardReal User

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.

2019-07-31T05:52:00Z
author avatar
Real User

We are just beginning development with this solution, so we're currently starting with the on-premises version. So far, I haven't been disappointed by the tool. I have not explored the dashboard tuning feature yet, so I don't know if there are things we can do, like building our own matrixes or choosing deployment preferences, but I hope that will be the case. I'd rate the solution ten out of ten.

2019-07-31T05:52:00Z
author avatar
Top 5LeaderboardReal User

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 that's something that needs to be evaluated quite early. There are lots of benefits to the catalog, but also a bit more admin attached to it. Another consideration is real-time processing needs. If this is a requirement then I would recommend against using this solution, unless the next version has a new set of features specifically for real-time processing. I would rate this solution an eight out of ten.

2019-07-30T10:41:00Z
author avatar
Real User

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 enterprise edition has. You can download it, put it somewhere and use it as a development or testing area. Then, if you like it, look to purchase it. We're looking to move more to the cloud at some point. I don't know when, but we'll be doing more research before we do. Overall, I think for what this solution does, it's pretty much all there. I don't see any way or any changes that can be made to make it work faster, or easier. I know the tool inside out, so we know what to do with it. The other solutions that I have looked at appear to be very good in certain situations. These are good for specific information, for situations that cover everything. With SSIS, it is specific to SQL and what we do, but it's lacking in some things like logging. Monitoring itself, for example, is what is missing. I would rate this solution an eight out of ten.

2019-07-30T10:41:00Z
author avatar
Top 20Consultant

We are using the 2014 Public Cloud version of the solution, under Microsoft Azure. In terms of recommending the solution, it obviously depends on the level users you have. If you mainly have a simple graphical based user then maybe you could go for SSIS. If you want to take control of the whole ETL process, you should look for another tool. I use Informatica PowerCenter as well. That's a bit more of a robust ETL solution. I would rate the solution at six out of ten.

2019-07-29T10:11:00Z
author avatar
Top 20Real User

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 ensure data lineage. I would rate this solution eight out of ten.

2019-07-29T10:11:00Z
author avatar
Real User

Overall, I am quite satisfied with this product. I would rate this solution an eight out of ten.

2019-07-28T07:34:00Z
author avatar
Top 20Real User

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 other Microsoft products because they are very easy to use. There are very handy tools. It's very user-friendly and has a good dashboard. I would rate the solution nine out of ten.

2019-07-18T11:31:00Z
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,041 professionals have used our research since 2012.