?
SolvedPrivate

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

Posted on 2015-01-06
3
Medium Priority
?
31 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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

592 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