SSIS Tutorial Part 123-Get Delete/Update Record Count From Execute SQL Task & Write to File

SSIS Video Scenario:

We want to create an SSIS Package in which we will be using a Stored Procedure, which will delete and update some records and return us the delete and update record count. Once the Stored Procedure is completed, we want to log the record count to a file file for our reference. We will append the record to flat file.

In this video we will learn how to returned Number of records deleted or updated by a Stored Procedure that we called in Execute SQL Task.

You will be able to learn following items from this video demo

How to Create SSIS Package from Scratch
How to create variables to hold the values from Execute SQL Task
How to Create Stored Procedure that will return Delete and Update Record Count
How to Map Store Procedure output to variables in SSIS Package
How to Write Variable values to Flat File

Blog post link for the video with scripts

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers