How to use Stored Procedure in Oledb Source in SSIS

In this video post , You will learn How to use Stored Procedure in OLE DB Source in Data Flow task and pass parameter to Stored Procedure.

We encounter so many scenarios where we have to use Stored Procedure in OLE DB Source.

OLE DB Source with Stored Procedure in SSIS