2014-02-26T18:20:00Z

What do you like most about SSIS?


Hi Everyone,

What do you like most about SSIS?

Thanks for sharing your thoughts with the community!

Guest
2020 Answers

author avatar
Top 5Real User

The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline.

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

The most valuable features of this solution are the fast insert and fuzzy logic matching.

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

This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language.

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

It has good data integration and good processes.

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

The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great.

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

The setup is straightforward. It's very easy to install.

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

With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server.

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

The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent.

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

The initial setup of this solution is very straightforward.

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

It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft.

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

The simplicity of the solution is great. The solution also offers excellent integration.

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

It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs.

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

I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import.

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

Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture.

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

The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions.

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

There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information.

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

It's already very user-friendly and has a good dashboard.

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

The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT.

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

It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud.

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

Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools.

2014-02-26T18:20:00Z
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,283 professionals have used our research since 2012.