Solved! Go to Solution.
You can not have dbtype as String for MSSQL, either you need to select VARCHAR or NVARCHAR.
The String datatype could be from your source.
Now, when we define any column in Sql Server to be of length NVARCHAR(20) but store data into them let's say of 8 characters there will be no unnecessary white spaces be present in the column when you select the data from the column.
Ex: as you could see I stored 8 char so the length says 8 but DATALENGTH will show 16 which depicts the actual size being utilized.
If you are seeing unnecessary white spaces in your destination side would recommend to TRIM the data (in tMap itself) and then perform the load.
Thanks for the assistance!
Guess it was bad foundation when I didn't put much attention on data types. Have changed to VARCHAR and all is working fine! Thanks for the help, cheers!