SSIS Room for Improvement
We purchase an add-on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package.
I believe there are ways to build a model and set variables so that it can be a generic process.
In my next system, I would like to have a generic process that would handle all the logging and processing in a model that can be modified and enhanced as the need for a better process, or different statistics to be logged is discovered. I'd want this in a way that the model can be changed and all the processes, with their unique parameters, could all be changed with the model upgraded.View full review »
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.
As an update, now SSIS offers big data components as well.View full review »
When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side.
Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console.
BI Architect at a retailer with 10,001+ employees
It is an out-of-date product, that we shouldn't be using anymore, as it no longer has many positive aspects.
It is an old tool. We make an effort not to use it. It's a legacy tool, that is nearing the end of its useful life. There could be some good things but we try not to get into that.
We have selected to go with another tool. SSIS should not be used whatsoever anymore. There are new versions, that are cloud-based, which are much more improved and much more feature complete.View full review »
Senior Analyst at a tech services company with 1,001-5,000 employees
Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion.View full review »
SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality.View full review »
The solution could improve on integrating with other types of data sources. We had issues with connecting to Oracle, it did not do as good of a job as it did with SQL servers.
In my experience, more efficiency is needed when it comes to dealing with huge volumes of data. However, this is also dependant on the server capacity.
In an upcoming release, they should update the features to facilitate efficient data transfers.
Data Architect at AMP Capital
It's difficult to refactor SSIS. It gets cumbersome to reuse the solution.View full review »
Admin at IEC (Electoral Commission of South Africa)
It would be nice if you could run SSIS on other environments besides Windows.View full review »
Sr. Training Manager with 201-500 employees
One of the problems I ran into was that the database that I had had a status. I couldn't always flip the status, so I didn't know what data I already had. I had to use SSIS to grab a bunch of data and check the database to see if I needed to insert it. It works okay, but as I plan better, I'm trying to weed it out. SSIS is a bit prickly because anytime you go and change something, it tends to break. That's because there is metadata behind the tool.
I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors.View full review »
Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster.
It is an easy solution but needs some improvement. The creation of the measure in the DAC's model could be improved.View full review »
Director at a tech services company with 11-50 employees
The security could be improved, as it is more important in our context.View full review »
I would like to see SSIS improve the collection of data trail servers and reporting. Future releases should improve the data lineage, as it currently is not good.View full review »
I would like to see more features in terms of the integration with Azure Data Factory.View full review »
Senior Associate at PwC Acceleration Centers
SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data.
It runs a little bit slowly, although this may be because of our laptops.
I would like to see better integration with Power BI.View full review »
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees
The solution could improve by having quicker release updates.View full review »
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees
I haven't found too many successful scaling options and that's something that could be improved.View full review »