varchar60 to varchar40

[ds_is_fun]

My job aborts even Im trimming varchar60 to 1,40 when writing to target type varchar40.
Do I use something like varchar0 convert function for this too as best practice?

[ambasta]

It Seems there are some other problem..
did you try (input_link.column[1,40])
and what i will suggest is...do not do any transformation..just try to send it ..it should automatically take care.

[ray.wurlod]

I'd probably use Left(InLink.TheString,40) - since I think it's better "self documentation" - but only after consulting the business to obtain a business rule to govern the situation that Len(InLink.TheString) > 40.

[ds_is_fun]

I have certain moves from varchar(60) to varchar(40) and some char(30) to char(40) and I have applied left(colname,40) and left(colname,30). It still fails with the message below on SQl server 2005 in DS-
APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver]String data, right truncation
[DataDirect][ODBC SQL Server Driver]String data, right truncation
[DataDirect][ODBC SQL Server Driver]String data, right truncation
[DataDirect][ODBC SQL Server Driver]String data, right truncation

[Maveric]

Try with RCP off.

[ds_is_fun]

RCP is off.

[ds_is_fun]

I changed the column lengths to be equal on source and target side.
I still get the same error -
APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver]String data, right truncation
[DataDirect][ODBC SQL Server Driver]String data, right truncation
[DataDirect][ODBC SQL Server Driver]String data, right truncation

[ds_is_fun]

Its a bug with unicode patch. I had to delete unicode description from extended and send the job over to tech support.