Hi everybody,

I use DTS from SQL Server 2000 P3

Does anybody know/have any recommendations on how to capture a number of
processed rows from transformation task? I need it for logging purposes.

Thank you,
Alex.

At the end of the task you can use an Active Script task and get the
following properties of the task

RowsComplete
RowsInError


allan


"Alex Prints" <AlexPrints (AT) discussions (DOT) microsoft.com> wrote

Thank you Allan! It works.

The only one thing. I want to pass the RowsComplete value to stored
procedure. It looks like I can do it in 2 steps only.
1. Capture the RowsComplete value into the global variable (ActiveX task).
2. Run stored procedure which accepts an input parameter from global
variable (Execute SQL task).

Is there an easier way to do that??

Thanks,
Alex.

"Allan Mitchell" wrote:

Also it took me a while to find the name of the task
("DTSTask_DTSDataPumpTask_1") and I don't see any way to edit it in the GUI.

Is it possible to edit it??


"Alex Prints" wrote:

Most people find either of these two articles helpful in situations like
this.

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)


Allan

"Alex Prints" <AlexPrints (AT) discussions (DOT) microsoft.com> wrote

Ok So you can change it using disconnected edit (right click the
designer surface) but if you do then make sure you change the associated
TaskName property of the associated step as well.

Allan

"Alex Prints" <AlexPrints (AT) discussions (DOT) microsoft.com> wrote

Thank you, Allan.

It works.

"Allan Mitchell" wrote: