Stored Procedure Output Columns

• Richard Gardner-291039

  Hall of Fame

  Points: 3603

  More actions

  January 10, 2006 at 8:25 am

  #364635

  Hi,

  I'm trying to use a stored procedure as source data in my data flow. I've attached to my OLE-DB link fine, and I can EXEC the SP and get a preview of the data.

  However, I don't understand why it will not recognise any output columns, my external columns is blank (when I go to EDIT - Columns everything is blank).

  I've got an inkling I need to fool SQL server by running the full query and then going back and redefining the source and EXEC, but I've had no joy as yet.

  Any ideas?

  Thanks

  Rich

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 10, 2006 at 2:21 pm

  #613932

  Just taking an absolute stab in the dark here. Are your columns names? If so, sorry, no clue.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!