Alan

thanks for the previous help, im still trying to avoid
having to go that routr. In an ExecuteSqlTask is there a
way to assign the @@rowcount to a global variable?

In article <007f01c3c004$5b22df00$a301280a (AT) phx (DOT) gbl>, Peter Newman
<anonymous (AT) discussions (DOT) microsoft.com> writes

Try some SQL like this-

SET NOCOUNT ON
UPDATE dbo.DataPump255
SET Col1 = Col1
SELECT @@ROWCOUNT AS CountOfRows

then click Parameters, Output Parameter, Row Value, and map
"CountOfRows" to the global variable you want.

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

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

Wrap the UPDATE in a stored proc and return the value through an OUTPUT
parameter

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

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Peter Newman" <anonymous (AT) discussions (DOT) microsoft.com> wrote