SSIS Other Advice
I'd rate SSIS an 8 out of 10 for its overall performance. I would recommend SSIS for its ease of use. Whether you're a beginner or experienced, it's intuitive and allows for easy development of logic and infrastructure.
View full review »The solution is easy to maintain. SSIS is a handy tool but requires vast knowledge to build the pipeline using it. I advise others to go for SSIS if the user is versed in developing a pipeline. Otherwise, you can quickly build a pipeline using multiple user-friendly solutions.
I rate the solution as a ten.
View full review »I was a user.
If you want to perform some transformation or data warehouse and the product is used for data analysis purposes, it's a good option. You can perform some transformation, et cetera.
I'd rate the solution eight out of ten. It was very useful for day-to-day tasks.
View full review »Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,995 professionals have used our research since 2012.
I rate this solution an eight out of ten. Regarding advice, SSIS is good. However, everything is shifting to cloud, and in other organizations, everybody's moving to Azure which is much easier to use. We haven't worked with Azure, so I can't compare it to SSIS at this time.
We highly recommend this solution as it is comparable with all of the major ETL software on the market. However, it should be noted that this is an enterprise class tool; it requires a team to be commissioned to do the proper development, there is a lot of standard documentation that comes with it, and a permanent team will be required to maintain it. So whilst it is a high-performing product, it requires a lot of commitment to optimize its use and capabilities.
I would rate this solution a nine out of ten.
View full review »We're using Visual Studio 2019 and SQL Server Integration Services 3.16.
I'd advise potential users to go and learn Azure and use that. Use Data Factory, not SSIS.
I'd rate the solution six out of ten.
View full review »I have managed a complex data transformation process in my company with the solution's transformation functions. Previously, I worked at my company with the data streaming destination in SSIS.
For integration purposes, my company uses SSIS connection managers. With SSIS, I can also get data locally installed in Power BI and design the dashboard.
I mostly rely on the dashboards provided by Power BI instead of SSIS.
I use SSIS for the data integration process. I don't use Power BI that much for the data integration process.
The data warehousing capabilities of SSIS are okay.
If you are not using any product that offers integration services in your company, then you can start using SSIS for your organization's applications.
The debugging and error handling capabilities improved our company's data integration task, as the tool helped me detect many issues.
The benefit of the product is that there are a lot of online tutorials available about the tool. Users will not face any hurdles when trying to search for information about the product online.
I rate the tool an eight out of ten.
We are end-users.
The SQL version that we are using is 2019. However, I'm not sure about the exact version of SSIS we're using. We installed it with the 2019 version.
I'd rate the solution eight out of ten.
View full review »HÖ
reviewer2305518
Business Intelligence Architect at a financial services firm with 5,001-10,000 employees
For those interested in SSIS, my advice is to go for it because it is a simple and effective solution. Even without deep knowledge, there are ample resources, including comprehensive documentation from Microsoft. Exploring their documentation provides access to numerous samples and best practices, making it user-friendly, especially for developers. So, don't hesitate to leverage the available materials and give it a try. Overall, I would rate SSIS as an eight out of ten.
I'm not sure which version of the solution I'm using.
Before starting with SSIS, a person needs to understand the concepts of SSIS. They need some time to get comfortable with the product before jumping in. When I first started, I wasn't aware of a lot of things. Therefore, at first, it was a bit difficult. However, it gets easier with time.
I'd rate the solution eight out of ten. It's flexible and very effective in terms of PLS skill programming. You can get real-time data from SSIS.
View full review »I'm an end-user.
We are using the latest version of SQL Server 2019. Typically, I start on-prem and move to the cloud.
It's a good tool for merging data from various data sources. We can have automated administrative functions and data-loading features. We can populate the data for the data warehouse and for data merges. This is one of the best analytic tools for a person or enterprise. We can recommend it for data analysis and data analytics purposes.
I'd rate the solution ten out of ten.
View full review »I rate SSIS seven out of 10. I would recommend using a cloud solution if possible, but if you need an on-prem product, SSIS is a good option. If you want to start using SSIS, there is a learning curve because SSIS isn't an easy solution to use. It's complicated, so you have to learn about the components and their functionalities to use them to meet your requirements.
DM
Dominic Mackenzie
Data Architect at AMP Capital
I rate SSIS nine out of 10.
View full review »VS
Vineth Suresh
Senior Associate at PwC Acceleration Centers
This solution was one of the easiest versions to use compared to other vendors' solutions. I would recommend SSIS to others.
I rate SSIS a nine out of ten.
This solution has all the functions needed. It is a complete solution and they are always adding additional features.
View full review »I would definitely recommend SSIS and I would rate SSIS a seven on a scale of one to ten.
View full review »SR
Sérgio Rita
IT Manager at European University
We still have a few versions running. The one that we use the most is the 2017 version.
I'd recommend the solution to others. I'd rate it seven out of ten.
If you are deploying a data strategy for your company, you need more than SSIS. If you need to go fast and implement some ETL processes with no help, it's quite easy to do and learn.
View full review »My advice to others that want to implement SSIS is they should watch a video or a tutorial for eight hours to implement a project for ETL. If you would like to migrate to SSIS, and link to the data sources, it will take approximately 30 minutes to watch a video tutorial on YouTube. You can search for the topic you are wanting to do, and you'll find the solution. There is a huge community to find the tutorials you need.
I rate SSIS an eight out of ten.
View full review »AS
Azeezulla Sheriff
General Manager IT at a manufacturing company with 10,001+ employees
I'd give SSIS a rating of seven out of ten.
View full review »LD
Letarik Terefe
IT Project Management /Research & Development Team Leader at Ethiopian Roads Administration
I've used the 2014, 2016, and 2019 versions of the product.
I'd recommend the solution to others.
I would recommend the solution to others.
Overall, I can rate the solution an eight out of ten. We're pretty happy with it.
View full review »SB
Sipho Ngubonde
Admin at IEC (Electoral Commission of South Africa)
I rate SSIS eight out of 10. I would recommend it.
View full review »TY
TarekYehia
Technical Consultant at LinkDev
My company is a Microsoft partner, and we use multiple Micorosft products.
We're using the latest version of the solution.
I'd recommend the solution to other users and companies.
I'd rate the solution eight out of ten.
View full review »MB
MichaelBarnett
Sr. Training Manager with 201-500 employees
I'm not a fan of SSIS itself. I would rate out-of-the-box SSIS a four out of 10, but with the ZappySys tool, it is a pretty good solution, and then I would rate it an eight out of 10.
View full review »Overall, I rate the solution an eight out of ten. There is room for improvement.
View full review »I would recommend SSIS to others who would be interested in using it.
I would rate SSIS an eight out of ten.
View full review »YY
reviewer1436226
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees
I rate this solution eight out of 10.
View full review »SSIS is a cheaper solution, and I would recommend it.
On a scale from one to ten, I would rate it at seven.
View full review »EL
reviewer928125
BI Architect at a retailer with 10,001+ employees
It's actually a tool that we're attempting to eliminate. That should not be used. It's an old piece of equipment. That should not be used in any way.
If I was asked five or six years ago, I would recommend this solution, but not anymore.
I would rate SSIS an eight out of ten.
MB
reviewer1656567
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees
Overall, I am quite satisfied with this product.
I would rate this solution an eight out of ten.
View full review »AN
Alireza Nikseresht
CEO at Shiraz University
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.
View full review »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.
View full review »XZ
Xiaoqing Zou
Integration developer at Blackwoods
It does its job. I'd probably rate it a six out of ten. Performance could be better.
SSIS is a good fit if you're heavily invested in on-premises Microsoft products. If you have a more diverse tech stack, better ETL tools might be available. Microsoft often limits how its products interact with others.
View full review »Overall, I rate SSIS an eight out of ten.
View full review »I rate SSIS six out of 10. SSIS can get the job done for bigger datasets. However, SQL Server lags if you're working with more than a terabyte or petabyte of data. I recommend exploring the tool because most of the video tutorials on the internet are outdated, and the official Microsoft documentation is geared toward advanced users. Beginners will have a hard time. You need a senior engineer to teach you, or you must explore the tool on your own.
View full review »SSIS is best suited for small and medium companies. I would rate SSIS eight out of ten.
View full review »MJ
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
Overall, we remained in a good position and in control while using SSIS. We didn't face any challenges.
View full review »IL
Ismail Lahbabi
Data Engineer at a tech services company with 11-50 employees
I would rate SSIS a six out of ten. I prefer Talend over SSIS.
View full review »MG
Prodown567
Technical Product Owner, Team Lead at ARCA
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.
View full review »SP
Sasidhar Parupudi
Principle Consultant at Keyrus South Africa
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.
MP
reviewer1194996
Senior Analyst at a tech services company with 1,001-5,000 employees
I rate SSIS eight out of 10. I recommend it.
View full review »IS
Igor Smirnov
Director at Netica d.o.o.
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.
View full review »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.
View full review »CG
ChitraGovindasamy
BI Consultant at a tech services company with 201-500 employees
Customers have moved on pass SSIS and use Azure Data Factory, Databricks or something similar. We have a few of our customers looking to moving on to Informatica or Talent. This is how I was led to itcentralstation.com, to learn more about SSIS and how it was compared to Informatica.
I have never had a situation where a particular transformation was not possible in SSIS. We have always been able to meet the demands of our need with SSIS.
I rate SSIS an eight out of ten.
View full review »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.
View full review »I rate SSIS seven out of 10. This is the only product I've used so far, so I don't know how it compares to others.
View full review »AS
AhmedShaban
Database Consultant
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.
View full review »SA
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
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.
View full review »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.
View full review »The good:
- Straightforward, intuitive, quick to learn
- Built-in debugger: variables, data viewers, breakpoints - everything you would expect from a modern software development tool
- Sleek, snappy UI
- Great flexibility with storing and deploying ETL components
The bad:
- Third party plug-ins may become incompatible with future versions of SSIS
- Upgrading is usually painful and time consuming despite what MS says
- Compatibility issues may arise when used with non-Microsoft technologies
In summary, this is a good product and I recommend it. For people that are working in a Microsoft environment with the SQL Server database, it's the most recommended tool.
I would rate this solution an eight out of ten.
View full review »The solution is working fine and it is useful. The only problem is the stability.
I rate this solution as a seven out of ten.
View full review »If an organization has the money, I recommend they use Informatica.
I would rate SSIS a seven out of 10 overall.
View full review »RH
RajeshHegde
Assistant Manager at a tech services company with 10,001+ employees
Don't worry, go ahead.
View full review »KS
KirillSlivchikov
Owner at 7Spring Consult
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.
View full review »JF
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
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.
View full review »I would rate this solution an eight out of ten.
View full review »
You need to have Microsoft SQL Server (Enterprise Edition) licensed to run Microsoft SSIS on your production environment. Like every other Microsoft product, It offers a very vibrant MSDN community along with Microsoft support staff for assistance.
View full review »
ST
DevoSft67
Software Developer at a transportation company with 1,001-5,000 employees
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.
View full review »Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,995 professionals have used our research since 2012.