2016-05-11T19:39:00Z

What needs improvement with SSIS?


Please share with the community what you think needs improvement with SSIS.

What are its weaknesses? What would you like to see changed in a future version?

Guest
2121 Answers

author avatar
Top 5PopularReal User

SSIS largest weaknesses right now are 1) Visual Studio/SSDT is only 32 bit. It needs to be 64 bit because that's the only thing that gets deployed and SSDT gets extremely unstable when your application gets large - likely because you start going over the max memory limitation. 2) it has changed very little in many years.  


Reality check: Microsoft has shifted focus to ADF. But ADF is not yet a valid replacement for SSIS (in fact not even close). ADF is far too painful to do just simple things that we can do with SSIS in our sleep. 


But that leaves us with the reality that SSIS will likely never get much attention. You can ask for improvements all you want but we are unlikely to ever see them. ADF is the future like it or not. Which is fine if you're starting from scratch but for those of us with thousands of SSIS packages we aren't converting anytime soon. Welcome to legacy software folks. I've had to abandon many great software packages over my career not because they were inferior but because the vendor simply abandoned them. One aspect of IT that I've never gotten used to.


So if you're starting out with a new project, I would seriously recommend testing your requirements against ADF and only using SSIS if ADF cannot meet your needs. And if you do need to use SSIS do it with Azure-SSIS IR or Execute SSIS Package activity.

2020-10-05T00:25:23Z
author avatar
Top 5Real User

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.

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

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.

2019-10-31T19:09:00Z
author avatar
Real User

Tuning using this solution requires extensive expertise to improve performance.

2019-08-20T01:15:00Z
author avatar
Real User

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.

2019-08-04T07:38:00Z
author avatar
Top 20Reseller

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

2019-07-30T10:41:00Z
author avatar
Top 5LeaderboardReal User

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.

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

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.

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

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.

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

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.

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

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.

2019-07-18T11:31:00Z
author avatar
Top 5Real User

The UI could use refinement. I would like to see more standard components out of the box, such as SFTP, and data compression components.

2019-05-01T23:14:00Z
author avatar
User

Metadata management. A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened.

2018-07-09T00:32:00Z
author avatar
Top 5LeaderboardConsultant

Scalability of SSIS needs some improvement. Seems to get sluggish as soon as we hit a high volume of data.

2016-05-11T19:39:00Z
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,141 professionals have used our research since 2012.