Have you had this problem before with a stored procedure that has a temporary table?
While I was using a stored procedure as a source for my OLEDB connection, No columns was listed in the source editor.
After some research, I landed at
http://msdn.microsoft.com/en-us/library/ms173839%28v=sql.105%29.aspx
Just add:
SET FMTONLY OFF
exec STOREDPROCEDURE
This will force the parser to return only the metadata to SSIS.
Hope that helps and feel free to share any findings on when do you get this issue.
While I was using a stored procedure as a source for my OLEDB connection, No columns was listed in the source editor.
After some research, I landed at
http://msdn.microsoft.com/en-us/library/ms173839%28v=sql.105%29.aspx
Just add:
SET FMTONLY OFF
exec STOREDPROCEDURE
This will force the parser to return only the metadata to SSIS.
Hope that helps and feel free to share any findings on when do you get this issue.
Thanks, that helped me...
ReplyDelete