Patent ID: 7860905

Claim:
A computer-implemented method of creating a modularized data flow logic portion comprising: creating a flowlet definition for a flowlet by providing one or more data flowlet components, each of the data flowlet components having flowlet internals, and one or more of inputs and outputs; providing a flowlet reference component configured to link the flowlet definition to one or more external data flows, each of the one or more external data flows comprising a SQL Server Integration Services (SSIS) data flow having one or more of inputs and outputs, thereby configuring the flowlet for incorporation into each of the one or more SSIS data flows; providing a flowlet metadata mapping component configured to isolate boundaries of the flowlet definition logic from the one or more external SSIS data flows by mapping source and destination flowlet component inputs or outputs to the flowlet reference component, which configures the flowlet for execution and testing as a stand-alone data flow; and merging the flowlet to the one or more SSIS data flows.