When retrieving data from ODBC, varchar columns show data up-to 255 bytes

Issues
#1

When importing data from ODBC, varchar column shows up-to 255 bytes. If you hit this issue you can work around it by changing your select statement and CAST the column like below

select CAST(Job AS varchar(1000)) ...