Home Forums SQL Server 2005 SQL Server 2005 Integration Services Stored procedure as a source error RE: Stored procedure as a source error
corey.collins
Valued Member
Points: 67
More actions
July 21, 2016 at 11:21 am
#1891397
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.