<div>
What progress you have made so far on this? I mean anything you have tried which is not working? Any errors or area where you are facing challenge?
</div>


What progress you have made so far on this? I mean anything you have tried which is not working? Any errors or area where you are facing challenge?

<div>
Due to Author's inactivity despite having been provided plausible solutions.
</div>


Due to Author's inactivity despite having been provided plausible solutions.

<div>
<div class="content wysiwyg-content">
I WANT TO COUNT THE NO OF INSERTS DONE IN TARGET TABLE FROM FLAT FILE SRC USING SCRIPT TASK IN FOR EACH LOOP CONTAINER DYNAMICALLY.<br />
CAN ANY ONE PROVIDE ME THE c# OR vb SCRIPT TO COUNT THE NO OF ROWS INSERTED AND ALSO SEND THE MAIL AFTER COMPLETING THE INSERTION AND NO OF ROWS INSERTED.
</div>
</div>


I WANT TO COUNT THE NO OF INSERTS DONE IN TARGET TABLE FROM FLAT FILE SRC USING SCRIPT TASK IN FOR EACH LOOP CONTAINER DYNAMICALLY.
CAN ANY ONE PROVIDE ME THE c# OR vb SCRIPT TO COUNT THE NO OF ROWS INSERTED AND ALSO SEND THE MAIL AFTER COMPLETING THE INSERTION AND NO OF ROWS INSERTED.

In script task no of inserts count and sending mail VB or C# code required

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.