OLE DB Command using stored proc in SqlCommand

[GFullington]

Configuring an OLE DB Command, need to update each record with a value returned from a stored proc.

The stored proc requires an output variable to store the result from the stored proc.

I then want to update the record with the returned value and write the record to a new destination.

I have declared Param_0 as an external column under inputs.

I have mapped the input column "newid" to Param_0.

The SqlCommand is the following;

Declare @param_0 as binary(8);

execute rsp_getnewid 'SMARTReport',@param_0;

update [smart_report].[dbo].[tblSMARTReportTemp]
set newid = ?;

I know I am missing the where clause, not sure how to pass in a value for the where clause.

Since the OLE DB processes the recordset row by row, how do I update the current row with the returned value from the stored proc?