SSIS Room for Improvement

Senior BI Developer at a music company with 501-1,000 employees
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 and a couple of others. Sometimes, it is difficult to follow how executions are actually working. They are just one after another with an execution set. If you're running multiple packages at the same time, it's difficult to track which packages are running and to locate those specifically. Improving the login procedure would make our reporting easier on monitoring our ETL processes. View full review »
Data Scientist at a tech vendor with 501-1,000 employees
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, micro batching, that might work, but it is not as good for queuing real-time processing. This solution needs full support for real-time processing. The solution needs better support for XML and JSON. View full review »
Database Consultant
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 would make things easier. Data migration needs to be simplified. I've found that it is really difficult to match, especially regarding data types. The old records often have different data types than we have now have in newer databases. Converting or transferring this kind of data is very important, and right now it's very difficult. There were also not enough instructions from Microsoft in regard to this application or this technology, which can easily be improved upon. View full review »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
437,557 professionals have used our research since 2012.
Alireza Nikseresht
CEO at Shiraz University
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 nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines and SSIS now doesn't seem to support it in our databases. In future releases, it would be helpful to support new SQL databases. It would also be helpful if there was a way to use SQL with other languages like Python or ASP.NET. View full review »
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
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 an example of what I'd like to see in SSIS is something that I think is very effective in Informatica. In Informatica PowerCenter, you define your sources and destinations once and after that, you can simply drag and drop into the designer. It's quite a nice feature. I don't know if SSIS has that feature, but if they don't, if they could allow the setup system configurations in one step and then offer drag and drop functionality, that would be extremely useful. View full review »
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
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 already. Certain data quality checks should also be part of it. Currently, this is the biggest area that should be looked into. Data quality is an essential part of the integration process and ETL. Currently, only the data profiling task is there. View full review »
Founding Partner at Altdata Analytics
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 the performance of the server, new hardware, should you update your software. It advises you on how to optimize your system. It's AI and works as an artificial database manager. Microsoft doesn't have anything like this yet, but it would be nice if they did. View full review »
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
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. View full review »
BI Consultant at a tech services company with 201-500 employees
There are a lot of features that could make this solution better. There were some issues when we tried to connect it to data storage. It was a connection issue. There is also room for improvement in the underlying language. View full review »
Brian Dandeneau
Business Process and Strategy Specialist Advisor at NTTData
Scalability of SSIS needs some improvement. Seems to get sluggish as soon as we hit a high volume of data. View full review »
Technical Product Owner, Team Lead at ARCA
It's at a very early stage in terms of adopting the tool, so I can't speak to if there are areas for improvement just yet. Video training would be a helpful addition, however. View full review »
Sasidhar Parupudi
Principle Consultant at Keyrus South Africa
In terms of improvements to the solution, I don't think I have that expertise on it to recommend product enhancements right now. I've only used a few parts of it. Based on what I've used so far, I am happy with it. I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use. View full review »
Executive Director and Co-Founder at 7Spring Consult
The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time. If SSIS could make some new monitors or new features for finding the reasons for the problems in the processes and analyzing it for how to correct the issues, that would be great. View full review »
Igor Smirnov
Director at Netica d.o.o.
The solution should offer more information online for users of SSIS. There are only a few general data sources available, but it would be helpful if there was more extensive information. The solution could also use some more intelligent discs for data manipulation, or maybe some artificial intelligence as well. It needs more integration tools, so you can connect to different sources. View full review »
Software Developer at a transportation company with 1,001-5,000 employees
I would like to see an auto-scheduler feature in the Developer version of this solution. I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process. View full review »
BI and Report Development Technician at a tech vendor with 201-500 employees
I have had problems in the past with this tool. The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information. The main difficulty that I have had is to match different data types, where there were errors that I could not fix. I would like to see better integration with the control sources. View full review »
Bob Amy
Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.
This may be done, but upgrades to new versions required re-implementing each package. This is worse for us because we have about one thousand SSIS packages. Hopefully they are now allowing backwards compatibility. Generic processes should be used instead of custom code for each table. View full review »
Steve Seeber
Senior Director Business Intelligence at Xtivia
The UI could use refinement. I would like to see more standard components out of the box, such as SFTP, and data compression components. View full review »
Big Data Architect, Integration Specialist at Groundswell Group Inc
Tuning using this solution requires extensive expertise to improve performance. View full review »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
437,557 professionals have used our research since 2012.