Avatar of ametuer999

asked on 

Resultset in execute sql task

A variable is assigned in result set to get the no. of duplicate values in a sql execute task.But duplicates may not exist always,in that case sql execute task failing with this error message:[Execute SQL Task] Error: An error occurred while assigning a value to variable "CheckDuplicateID": "Single Row result set is specified, but no rows were returned.". How can i rectify it..could any expert solve my problem ASAP
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon