SSIS Tutorial Part 127.1-Get Execution Time of Multiple Stored Procedures from Execute SQL Task

SSIS Video Scenario:

Let's consider that we are running multiple Stored Procedure by Execute SQL Task in SSIS Package. We want to know which Stored Procedure is currently running? Also we want to capture the time taken by each of the Stored Procedure to Execute?

Items you will leaven in this video:

How to Create an SSIS Package from Scratch
How to Create Stored Procedure in TSQL
How to Log information in Audit Table Before and After Execution of Stored Procedure.
How to Call Multiple Stored Procedures in Execute SQL Task in SSIS Package

Blog post link for the video with scripts