Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SSIS - Storing Dataflow results to Object Variable with Recordset Destination

SSIS - Storing Dataflow results to Object Variable with Recordset Destination

SSIS - Storing Dataflow results to Object Variable with Recordset Destination

There are several methods to store the your data into Object Variable in SSIS. (See: SSIS - Mapping Full Resultset with Execute SQL Task to Object Variable)
The second method is by Dataflow Task and a Recordset Destination.

1. Drag and Drop Dataflow Task to Control Flow



2. Create a Object Variable


3. Drag and drop a Datasource


4.Drag and drop a RecordSet Destination and Map object variable


Now you are done with getting values to object variable.
, , , , [Edit tags]
Leave a Comment
  • Please add 4 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 3 Sep 2013 7:39 AM

    Maheshkumar S Tiwari edited Original. Comment: Added tags and minor formatting

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 3 Sep 2013 7:39 AM

    Maheshkumar S Tiwari edited Original. Comment: Added tags and minor formatting

Page 1 of 1 (1 items)