July 28, 2008 at 3:34 am
I'd like to use the output from a stored procedure as a source in a Dataflow. Using a simple OLE DB Source with an SQL Command is not working: I get no resultcolumns, although the preview gives me the desired output. Working with the Advanced Editor has not yield a solution.
I think I can get something to work with Execute SQL task and possibly temp tables, but I wonder if there is not an elegant solution to capture SP-output.
I have tried googling the Internet, but found nothing to fit my needs. Any hints?
Greetz,
Hans Brouwer
July 28, 2008 at 4:31 am
July 28, 2008 at 6:00 am
Found tyhat 1 too, and it sure did solve my problem.
Tnx.
Greetz,
Hans Brouwer
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply