Patent ID: 7860904

Claim:
A computer-implemented method for executing an incomplete data flow comprising: identifying an incomplete SQL Server Integration Services (SSIS) data flow having at least one missing or unknown source point, destination point or operation which must be accounted for before the incomplete SSIS data flow can be executed; providing one or more data flowlet components, each of the data flowlet components having an associated flowlet definition, flowlet internals, and one or more of inputs and outputs; connecting the data flowlet component to the incomplete SSIS data flow in place of the at least one missing or unknown source point, destination point or operation; providing a flowlet reference component configured to link the one or more flowlet definitions to one or more external data flows, each one or more external data flow having one or more of inputs and outputs; providing a flowlet metadata mapping component configured to map at least one of the inputs or outputs of the one or more external data flows by mapping at least one of the inputs or outputs of the one or more of the data flowlet components to the flowlet reference component; and executing the incomplete SSIS data flow using a package component, wherein the incomplete SSIS data flow that is executed has been modified to now include the data flowlet component in place of the at least one missing or unknown source point, destination point or operation.