I have an OLE DB Source control that I am using to collect data from a stored
procedure. THhe stored procedure first assembles the data in a #Temp table.
It then does some work to the #Temp table and finally returns the data via a
Select statment from the #Temp table. I have explicitly se the column names
in the select statment, without and different effect.
Ok, with this in mind, the control can't get the columns returned from the
SP because I am using a #Temp table. So I get the error, "Unable to retreive
destination column descriptions from the parameters of the SQL command." I
have found a work around by useing a permanent table but don't want the
overhead associated. Is there a way to assign these columns so I can use the
#Temp tables?
Thanks for any assistance you can provide!

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J

Hi sorourke1,

This issue is well documented on the forums and various blogs. The
usual suggested work-around is to use an in-memory table, but there
are other options.

Good luck!
J