I have had this issue occur and even set fmtonly off and set nocount on didnt fix it. The only solution was to change the data source to an ADO Net Source instead of OLE DB source.