SSIS: Using a Stored procedure inside a Ole DB Source

By | August 21, 2009

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.

  • Hello,
    Ugh, I liked! So clear and positively.
    Thank you