Is there an easy way to grab the number of rows exported from a stored procedure into a text file via DTS & insert the rowcount into a table



---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/

In message <#cMskOQ5DHA.2760 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, gunter
<river_witchhawk@-NOSPAM-yahoo.com> writes

You can get the row count from the DataPump2 object, RowsComplete
property less RowsInError property. Use some script like below to store
the value in a global variable-

Dim oTask
Dim oDataPump

Set oTask = DTSGlobalVariables.Parent.Tasks("DTSTask DataPump 1")
Set oDataPump = oTask.CustomTask
DTSGlobalVariables("Rows").Value = oDataPump.RowsComplete -
oDataPump.RowsInError
Set oDataPump = Nothing
Set oTask = Nothing


I would then use an Execute SQL Task to insert the value into your
table.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org