The following diagram demonstrates the execution workflow of an SSIS package which uses the DataDefractor SSIS data flow component:
- DataDefractor SSIS uses a standard SSIS connection manager to connect to one or more sample spreadsheets.
- In design-time, the SSIS developer uses DataDefractor Mapping Wizard to define a dimensional model and a data mapping schema based on the sample set of worksheets. During run-time DataDefractor SSIS uses this schema to parse and convert the input spreadsheets into a structured data model which is pumped directly into the SSIS output pipeline in the form of a star schema.
At this point, the output can be transformed, mapped to existing data structures, used to create new data marts or be appended to existing data warehouse schemas using standard SSIS data flow transformation and destination components.