SSIS Data Flow Components

4.4
(4 reviews)

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.

Find the Right Product

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 4 SSIS Data Flow Components reviews
LinkedIn Connections
SSIS Data Flow Components review by Rishu S.
Rishu S.
Validated Reviewer
Review Source

"I have 1 year experience in using SQL server data flow components"

What do you like best?

1) the drag and drop feature is easy and helps to perform complex functionality.

2) Components like SCD are very helpful. It load necessary components automatically.

3) it also allow to use c# or VB code.

4) it allows us to load data from multiple sources.

What do you dislike?

1) SSIS components do not consider performance aspects. It's very hard to find and fix performance issues with SSIS components.

2) it's hard to debug issues as SSIS do not allow debugging inside procedure.

3) SSIS do not have enough templates. It should have more templates to perform specific task.

Recommendations to others considering the product

It's a good option for loading data from various sources. It's easy to implement.

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

1) it helps to collect data from various sources. Right noe. We are using it to load/transform data from xml,CSV,excel,SQL server etc.

2) it's easy to work with SSIS components.

3) The chart and gauge components are very helpful for analysing the data.

Sign in to G2 Crowd to see what your connections have to say about SSIS Data Flow Components
SSIS Data Flow Components review by Divya A.
Divya A.
Validated Reviewer
Review Source

"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.

What On-Premise Data Integration solution do you use?

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

"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.

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

"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

There are not enough reviews of SSIS Data Flow Components for G2 Crowd to provide buying insight. Below are some alternatives with more reviews:

1
webMethods Logo
webMethods
4.1
(108 reviews)
Software AG's webMethods Integration Platform is a proven, pre-integrated software suite featuring the market-leading Enterprise Service Bus (ESB) that enables enterprises to rapidly integrate systems, services, devices, processes, business partners and data to provide new business value and improve business performance. Seamlessly integrated with webMethods API and Master Data Managment (MDM), webMethods suports the Digital Business Platform (DBP) which supports the rapid development for next generation applications.
2
Talend Data Integration Logo
Talend Data Integration
4.0
(46 reviews)
Talend offers open source middleware solutions that address big data integration, data management and application integration needs for businesses of all sizes.
3
Informatica PowerCenter Logo
Informatica PowerCenter
4.4
(37 reviews)
Power Data Integration Tool
4
SAP Data Services Logo
SAP Data Services
4.0
(29 reviews)
SAP Data Services allows you to deliver information to all your business functions with the ability to integrate, transform, and manage your data at the project or enterprise level.
5
IBM InfoSphere Information Server Logo
IBM InfoSphere Information Server
4.0
(27 reviews)
IBM InfoSphere Information Server is an advanced data integration platform that enables you to cleanse, monitor, transform and deliver data. The scalable solution provides massively parallel processing capabilities to help you manage small to very large data volumes. It helps you deliver trusted information to your key business initiatives such as big data and analytics, data warehouse modernization and master data management.
6
Atlas Logo
Atlas
4.0
(21 reviews)
Atlas provides for real-time, two-way integration between Microsoft Dynamics AX and the Microsoft Office System.
7
Centerprise Data Integrator Logo
Centerprise Data Integrator
4.3
(20 reviews)
Centerprise Data Integrator provides a powerful, scalable, high-performance, and affordable integration platform designed for ease of use by your business information experts, yet robust enough to overcome even the biggest and most complex data integration challenges.
8
Oracle GoldenGate Logo
Oracle GoldenGate
3.7
(23 reviews)
Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.
9
Neuron ESB Logo
Neuron ESB
4.3
(19 reviews)
Neuron ESB is an application, service and workflow integration platform that simplifies messaging, system integration and Web service enablement. Built on Microsoft .NET, Neuron ESB enables you to use existing in-house developer skills, reduce custom development, deliver solutions faster, and cut third-party integration costs.
10
TIBCO BusinessWorks Logo
TIBCO BusinessWorks
3.8
(19 reviews)
TIBCO BusinessWorks is a platform for developing new services and integrating applications with minimal code required.
Show more
Kate from G2 Crowd

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.