Overview
What is SSIS Data Flow Components?
Devart’s SSIS Data Flow Components allow users to integrate database and cloud data via SQL Server Integration Services (SSIS). The components provide data integration using SSIS ETL engine. They offer high performance data loading, convenient component editors, SQL support for cloud…
Pricing
SSIS Integration Database Bundle
$549.95
SSIS Integration Cloud Bundle
$749.95
SSIS Integration Universal Bundle
$999.95
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $549.95 one-time fee
Product Details
- About
- Integrations
- Tech Details
What is SSIS Data Flow Components?
Devart’s SSIS Data Flow Components allow users to integrate database and cloud data via SQL Server Integration Services (SSIS).
The components provide data integration using SSIS ETL engine. They offer high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.
SSIS Data Flow Components Features
- Supported: High performance data loading
- Supported: Convenient component editors
- Supported: SQL support for cloud data sources
SSIS Data Flow Components Screenshots
SSIS Data Flow Components Integrations
SSIS Data Flow Components Technical Details
Deployment Types | On-premise |
---|---|
Operating Systems | Windows |
Mobile Application | No |
Supported Languages | English |
Comparisons
Compare with
Reviews
Community Insights
- Business Problems Solved
- Pros
- Cons
SSIS Data Flow Components have proven to be a valuable solution for businesses looking to automate complex data transformation tasks. Users have reported saving significant amounts of time and reducing errors while collecting data from various sources, including Excel, SQL, CSV, and XML. The software's ease-of-use is highlighted by its drag and drop functionality, which allows users to perform complex tasks with ease.
One of the key business problems that this software solves is moving data into data warehouses. Users report that they can develop and deploy SSIS packages in a more timely manner, improving efficiency. Additionally, the product has been beneficial for organizations requiring historical data maintenance. Deployment and maintenance are not considered an overhead, so users can see a clear ROI on their investment in the product. While some users have experienced speed and reliability issues when syncing orders and order items to a database, customer service has been responsive to these issues providing patches to trial before purchase. Overall, the SSIS Data Flow Components provide a valuable solution to businesses looking to automate data transformation tasks and improve efficiency within their organization.
Fast Data Transfer: Multiple users have stated that SSIS Data Flow Components are an extremely fast and efficient tool for transferring data. The speed of data transfer is a crucial aspect of any ETL tool, making it a significant advantage for users who need to process large amounts of data quickly.
Ease of Use with Relational Databases: Reviewers have noted that the Execute SQL task in SSIS adds a lot of ease of use when dealing with relational databases. Some users who work frequently with these types of databases appreciate this feature as it saves them time and effort during the development process.
Flexibility and Adaptability: Several users have found that SSIS can be a flexible and adaptable tool that can work with a variety of data sources and systems. This adaptability is highlighted by features such as easy connection to MySQL database hidden behind an SSH server, simplifying the integration process with Salesforce, etc.
Setup Issues: Some users find the setup process fiddly and note that SQL Server Data Tools is necessary to run it. Additionally, the software only works on Visual Studio 2017 and not 2019, which can create compatibility issues for some users.
Missing Menus and Error Box Disappearances: Occasionally, when opening packages, side menus are missing from the software's user interface. Furthermore, the error box at the bottom sometimes disappears as well, making it difficult for reviewers to pinpoint and solve issues with scripts.
Limited Database Support: The software does not provide enough support for other databases like Oracle or Teradata. This limitation can make it challenging for some customers to use the product effectively.