使用存储过程将数据插入varchar字段时出现问题

I am uploading some data from DB2 to SQL2005. The table contains one text field that is 2000 characters long in DB2 but is set up as a varchar(2000) in SQL. I am uploading some data from DB2 to SQL2005. T