SolvedPrivate

Extracting the contents of a full result set from a Execute SQL Task in SSIS

Posted on 2015-01-06
3
25 Views
Last Modified: 2016-02-15
I have successfully used an Execute SQL task to insert the column values of a query into variables when employing a single row result. I would like to do something similar with a full result set. All I have been able to do is populate an object variable. The value of this variable = System._ComObject. I understand that this can be used in other SSIS components like a For Each Loop container. What is the process ? Thanks.
0
Comment
Question by:StampIT
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40534979
Hello,

In the below article complete process has been shown.


http://www.timmitchell.net/post/2013/05/28/using-the-ssis-object-variable-as-a-result-set-enumerator/

Hope this would help you
0
 

Author Comment

by:StampIT
ID: 40536783
I am in the process of trying this out. Thanks.
0
 

Author Closing Comment

by:StampIT
ID: 40538595
Thanks for the link.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Run an action on recently added records to a table 13 66
TSQL XML Namespaces 7 24
RAISERROR WITH NOWAIT 2 18
.NET Enums [Flags] & Bitwise Design Question 6 29
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question