I encounter a question today which was about using a Stored procedure inside a Data flow task, and use result of stored procedure which returned by output parameter beside other columns in Data Stream. Solution with sample: Suppose your stored procedure has an input parameter and output parameter. I show you a simple stored procedure Read more about Output Parameter of Stored Procedure In OLE DB Command – SSIS[…]