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...
In questa pagina del sito puoi guardare il video online SSIS Tutorial Part 123-Get Delete/Update Record Count From Execute SQL Task & Write to File della durata di ore minuti seconda in buona qualità , che l'utente ha caricato TechBrothersIT 29 aprile 2015, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 11,291 volte e gli è piaciuto 30 spettatori. Buona visione!
