“GiUpdateRowCount” Global Variable Created DTS package


Update TableName
From TableName2
Where TableName.Col1 = TableName2.Col1
SELECT @@Rowcount AS UpdateRowCount

Above Query is used in Execute SQL Task

Once I execute the Execute SQL Task, UpdateRowCount value should pass to
Global variable GiUpdateRowCount, but It’s not passing to Global variable can
you gays tell me how to get this from this task.

Thanks for providing solution

Hello Rajesha,

I assume you have set the output variable options. Try adding SET NOCOUNT
ON at the top of the SQL.

Dear Darren,
Thanks for your responce. It's related to DTS package.
Actually I wanted to pass @@Rowcount value to Global variable. Below code
is their in Execute SQL Task.

FYI:
Once I used Select query instead of Update Query then @@Rowcount value will
get in Global Variable. But I wanted to use update query.

Thanks and regards
Rajesha

"Darren Green" wrote: