u should delete the source adpter and recreate again,it will work because it takes old buffer thats why it showing error like that

place execute sql task create one variable package level and use row count transformation