Component "%1!s!" (%2!d!) has been removed from the Data Flow task because its output is not used and its inputs either have ...

Component "%1!s!" (%2!d!) has been removed from the Data Flow task because its output is not used and its inputs either have no side effects or are not connected to outputs of other components. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something.