Fail to execute store procedure in OLE DB Source in Data Flow

November 7, 2006 at 11:23 am | In IT, SQL Development, SSIS | Leave a Comment

When using SSIS for SQL 2005, running an SQL Command (Procedure) using an OLEDB Object may cause this error to trigger.

Use “SET NOCOUNT ON” in your procedure code to eleminate this error

No Comments Yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment

You must be logged in to post a comment.

Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.