Requirements :If the query return only one row and also specific column value and that column value required to use for some store procedure .
Solution :
On the First Execute SQL Task , Point the Result set to Single Row.
On the SQL Statement select top(1) userID from Testtbl , It will return the Id number
and assign this ID value to resultset user variable userIDResult as shown as below intend to use for next SQL Task parameter Mapping.
On the parameter mapping , we assigned Resultset variable that required for store Procedure.
Solution :
On the First Execute SQL Task , Point the Result set to Single Row.
On the SQL Statement select top(1) userID from Testtbl , It will return the Id number
and assign this ID value to resultset user variable userIDResult as shown as below intend to use for next SQL Task parameter Mapping.
On the parameter mapping , we assigned Resultset variable that required for store Procedure.
No comments:
Post a Comment