How to use output from SP as a source

• FreeHansje

  SSChampion

  Points: 11751

  More actions

  July 28, 2008 at 3:34 am

  #188596

  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

• hodgy

  SSCertifiable

  Points: 5906

  More actions

  July 28, 2008 at 4:31 am

  #849049

  have a look at the post on the Jamie Thomson's blog, i think this covers the same sort of issue:

  SSIS Junkie

  Tom

  Life: it twists and turns like a twisty turny thing
  

• FreeHansje

  SSChampion

  Points: 11751

  More actions

  July 28, 2008 at 6:00 am

  #849101

  Found tyhat 1 too, and it sure did solve my problem.

  Tnx.

  Greetz,
  Hans Brouwer