I am performing ETL from Sybase db -> tMap -> dboutput to MSSQL.
The problem I am facing is the schema for MSSQL. Say if I define the column to be of dtype string length 20, data mapped to this column will be forcefully created as a len 20 character, with unecessary white spaces .
May I know what are the available options for me to perform my ETL and ouput to MSSQL without this constraint i.e. taking the string from the source data as it is.
