I had the same error using TPT via SSIS (Attunity) querying Teradata. I just removed all whitespace from my query and it ran fine.
Using TRIM(column_name) helped! Though, I'm not certain on root cause. I am typing my column name and do not have any spaces that I can see to even trim; however, TD Studio seems to be adding something to my column name which must be trimmed out. Possibly a TD bug?