SSIS Getting Execute Sql Task result set object
I have an execute sql task item and it is getting multiple rows of data
from a stored proc.
Declared a variable ObjShipment under the variable table and assigned it
under the Result set with the following info:
Result Set: Full result set
Result Name: 0
Variable Name: User::ObjShipment
I have written a script task with the ObjShipment variable assigned to
ReadOnly an am wondering how to retrieve the data within it?
The stored proc returns multiple rows like Id, ItemId, DateCreated.., but
how do I retrieve them say if I am only interested in the ItemId? And
since it returns multiple rows there could be more than one ItemId.
I am new with ssis any help would be appreciated!
No comments:
Post a Comment