We just raised a $30M Series A: Read our story
2014-02-26T18:20:00Z

What do you like most about SSIS?

10

Hi Everyone,

What do you like most about SSIS?

Thanks for sharing your thoughts with the community!

ITCS user
Guest
2424 Answers

author avatar
Top 5LeaderboardReal User

The technical support is very good.

2021-09-01T10:50:13Z
author avatar
Top 10Real User

The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products.

2021-05-19T19:43:47Z
author avatar
Top 20Real User

The interface is very user-friendly.

2021-02-09T12:29:02Z
author avatar
Top 10Consultant

The script component is very powerful, things that you cannot normally do, is feasible through C#.

2021-01-24T15:50:19Z
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 10Real 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
Real User

The initial setup of this solution is very straightforward.

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
Real 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
Consultant

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
Reseller

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
Top 20Real 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
Real 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
Real 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
Consultant

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
Real User

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

2019-07-18T11:31:00Z
author avatar
Real 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
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: September 2021.
541,708 professionals have used our research since 2012.