Hi NischalBadarinathKashyap-8458,
Was the SQL Server table you want to import data a new table?
If it is a new table, you can increase the size in the “select source tables and views” page -> click Edit Mapping, then increase size of column.
If it is not, you can try to increase size of the column in the table.
Best Regards,
Amelia