SSIS: Using a Stored procedure inside a Ole DB Source

I wantend to use a stored procedure into a OLE DB Source, but this appeared not to work, with an error in SSIS “No Column information was returned by the sql Command” hmm, strange.

Thanks to the SSIS junkie blog i found an answer in the comments, it appears you to put

 SET FMTONLY OFF

 SET NOCOUNT ON

In the top of your sproc, SSIS then finds the necessary metadata to pass the columns of your result to SSIS.

One Reply to “SSIS: Using a Stored procedure inside a Ole DB Source”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.