Standard SSIS data flows rely on static, design-time metadata: column names, data types, and mappings are established when you design the package. Variables and expressions can change which table or file a component accesses, but the data flow still expects the configured column structure. Processing entities with different schemas or accommodating schema changes can therefore require manual updates to the package.
COZYROC SSIS+ addresses this limitation with dynamic data flows, powered by Data Flow Task Plus. DFT+ discovers column metadata and builds mappings at runtime, allowing the same ETL logic to process different files, tables, or application entities within the configured source and destination connections. Reuse one data flow across multiple entities and adapt to changing schemas with less manual rework.
Reuse your data flows
Configure the source and destination connection.
Reuse the logic for any table/entity.
Use variables and expressions to select source and destination tables, file paths, sheet names, or application entities. Data Flow Task Plus discovers their column metadata and builds the mappings when the flow runs.
Run the package for one source–destination pair, or place DFT+ inside a loop to process multiple pairs in sequence. Loops can even be run in parallel with Parallel Loop Task
From CSV and Excel files to SQL Server tables and SaaS applications such as Dynamics 365, Salesforce and many more.
Automate bulk processing
Export multiple database tables to separate files, load a series of incoming files, or repeat an integration across application entities. A loop selects each pair; DFT+ refreshes its metadata and mappings on every iteration..
Simplify cloud migrations
Reuse a dynamic data flow to move entities from an on-premises application to its cloud counterpart, such as Dynamics CRM to Dynamics 365. Process entities in dependency order so prerequisite records are in place.
Adapt to changing schemas
Schema drift is when the structure of data changes over time, such as columns being added, removed, renamed, or having their data types changed. It can break data pipelines that expect the data to follow a fixed schema.
Handle schema drift with less maintenance.
When a source or destination schema evolves, manually updating column metadata and mappings can become a recurring task. DFT+ refreshes that information at execution time, reducing the need to redesign and redeploy packages for supported schema changes.
Current metadata. Runtime mappings. Less manual maintenance.
Work with the current schema
Read column metadata when the package runs, so the flow can respond to changes in the configured sources and destinations.
Reduce repetitive updates
Spend less time maintaining column definitions and rebuilding mappings as data structures evolve.
Keep your ETL logic reusable
Let runtime metadata handling support the integration you have already designed.
Knowledge Base
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.