For me, I was getting this same error because my query was unintentionally returning a varchar(max) data type. Apparently that will cause SSIS to return this error as well. I...