Join the 1500 companies using G2 Track to manage SaaS spend, usage, contracts & compliance.

SSIS Data Flow Components

4.6
(5)

Performance-optimized SSIS Data Flow Source, Lookup, and Destination components for databases and cloud applications.

Work for SSIS Data Flow Components?

Learning about SSIS Data Flow Components?

We can help you find the solution that fits you best.

SSIS Data Flow Components Reviews

Ask SSIS Data Flow Components a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 5 SSIS Data Flow Components reviews
LinkedIn Connections
SSIS Data Flow Components review by Divya A.
Divya A.
Validated Reviewer
Review Source
content

"SSIS ETL Services"

What do you like best?

Making connections is easy with SSIS. You can track execution activity by just looking at data flow task progress. When converting source components to destination data types, the SSIS makes it super easy and takes care of metadata issues and synchronization on its own. All in all a very useful product for ETL design.

What do you dislike?

The product should have advanced mechanisms of error logging. If the container fails, the only way by which one can tell is by looking at error list output at the end of horizontal menu. The product should have capability of running enterprise level of jobs and monitor all jobs in a single screen just like Control-M.

What business problems are you solving with the product? What benefits have you realized?

ETL designing is super easy with this product. Maintaining historical data is really beneficial to any organization. Deployment and maintenance is not an overhead.

Sign in to G2 to see what your connections have to say about SSIS Data Flow Components
SSIS Data Flow Components review by User in Computer Software
User in Computer Software
Validated Reviewer
Review Source
content

"I have three year experience to use SSIS data flow components"

What do you like best?

1) The drag and drop feature of SSIS is easy and intuitive for the desired functionality.

2) The templates like SCD are easy to configure and use to do a lot of heavy work.

3) The runtime debugging is a great feature and helps to find issues in complex scenario.

4) the event handler feature is of great use. User can raise custom events for a specific action.

5) It also provide data transformations. These transformations help to change data as per requirement.

What do you dislike?

1) SSIS do not provide performance optimisation tools. Most of activities took place behind the scenes. So, user is required to do some heavy work to do fix performance issues.

2) SSIS do not provide debugging at its core level. Like user can see the results of a procedure at runtime. But, it do not show internal debugging of stored procedure.

3) SSIS do not provide enough templates. I think SSIS should provide basic template with multiple components and user should be able to configure them as per available/required resources.

Recommendations to others considering the product

It's a great tool to collect data from variety of sources.

What business problems are you solving with the product? What benefits have you realized?

1) It helps to collect data from variety of sources. Like, Excel,SQL,csv,XML etc.

2) it's easy to use this. User can perform some complex task with drag and drop.

3) it's easy to customise or modify existing SSIS packages.

What On-Premise Data Integration solution do you use?

Thanks for letting us know!
SSIS Data Flow Components review by User
User
Validated Reviewer
Review Source
content

"Benefits for ssis data flow"

What do you like best?

Ssis is very easy to use.

This etl tool can connect to multiple datasources and load data to multiple type of detinations like csv,Excel,database etc

What do you dislike?

Some times the ssis gives hang issue due to memory constrainst and we have to restart the solution

Recommendations to others considering the product

Good

What business problems are you solving with the product? What benefits have you realized?

We are using ssis data flow to load data from Hadoop to SQL database which is then used for dimentional modelling.

SSIS Data Flow Components review by Administrator in Financial Services
Administrator in Financial Services
Validated Reviewer
Review Source
content

"SSIS Data Flow components"

What do you like best?

The ease of moving data from multiple sources to SQL Server given the amount of transformations that are all possible to implement within SSIS

What do you dislike?

The clunky feel of the source wizard. I also would like to use something with a little more flexibility when interacting with MS Excel as well as MS Access

What business problems are you solving with the product? What benefits have you realized?

The business problems it is solving is moving data into our data warehouse. We exclusively use SSIS and the Data Flow Task to move data from our source systems into our warehouse

SSIS Data Flow Components review by Internal Consultant in Education Management
Internal Consultant in Education Management
Validated Reviewer
Review Source
content

"SSSI Data Flow Components"

What do you like best?

The components are intuitive and easy to use.

What do you dislike?

The IDE crashes on rare on some occasions.

What business problems are you solving with the product? What benefits have you realized?

We are able to get our SSIS packages developed and deployed in a much more timely manner,

Kate from G2

Learning about SSIS Data Flow Components?

I can help.
* We monitor all SSIS Data Flow Components reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.