June 4, 2019 at 9:32 am
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.
June 4, 2019 at 3:44 pm
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply