How to fix 'metadata could not be determined error in SSIS OLEDBCOMMAND'

• Kannan Vignesh

  SSC Eights!

  Points: 851

  More actions

  June 4, 2019 at 9:32 am

  #3650023

  I have an ssis package. In one data flow task, i am using oledbcommand task to run Stored procedure

  eg: exec adminstroedproc ? ? ?

  we have recently upgrade the sql server to 2017. Earlier it uses sql server 2008.

  Earlier it was working fine in OLEDBCOMMAND. After up-gradation it throws an error. When i executing this stored procedure directly in SSMS it's running good... But when i calling this stored procedure from OLEDBCOMMAND Task getting error message saying that

  " The metadata could not be determined because select statement in procedure uses a temp table.

  unable to retrieve destination column descriptions from the parameters of the sql command."

  I tried with global temp table and using with result sets as well. But still getting error. Can you please suggest.

• Phil Parkin

  SSC Guru

  Points: 247174

  More actions

  June 4, 2019 at 3:44 pm

  #3650146

  What does adminstroedproc  do? Or should it be adminstoredproc ?

  Is it returning anything? Presumably not, otherwise I would suggest using WITH RESULT SETS, which is the usual way of solving this problem.

  ---