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
http://sqlage.blogspot.com/2015/04/ho...
Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
http://www.techbrothersit.com/2014/12...
On this page of the site you can watch the video online SSIS Tutorial Part 123-Get Delete/Update Record Count From Execute SQL Task & Write to File with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 29 April 2015, share the link with friends and acquaintances, this video has already been watched 11,291 times on youtube and it was liked by 30 viewers. Enjoy your viewing!
