Tuesday, April 3, 2012

SSIS No Column Names in OLEDB Data Source

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.