Metadata could not be determined in SSIS OLEDB source

Asked May 11 '17 at 07:08

Active May 11 '17 at 13:32

Viewed 549 times

I am trying to use dynamic query inside OLEDB source, but getting

"Metadata could not be determined" error which is usual.

I used WITH RESULT SET (in SQL Server 2012) inside the Stored procedure to fix the issue, but the actual source is SQL Server 2005 where this fix is not working.

Is there any other way this can be resolved in 2005?

edited May 11 '17 at 13:32

Yahfoufi

2,220
1
22
41

asked May 11 '17 at 07:08

Ajay Agrawal

Have you checked this: http://stackoverflow.com/questions/19666817/using-dynamic-sql-in-an-ole-db-source-in-ssis-2012 ? – DenStudent May 11 '17 at 07:33
Yes, no solution for 2005. – Ajay Agrawal May 11 '17 at 08:53
I know this has been asked and answered for 2005 before, but I can't find it right away. Basically it's this answer: http://stackoverflow.com/a/18360265/1507566 – Tab Alleman May 11 '17 at 14:44

Metadata could not be determined in SSIS OLEDB source

0 Answers0