DRS Stage truncating the last character

splayer · Post by **splayer** » Tue Aug 29, 2006 3:47 pm

I am using DRS stage as a target to write to SQL Server. It is truncating
the last character of 4 of the columns. These are all char to varchar.
Any solution other than using ODBS Enterpsie stage.

splayer · Post by **splayer** » Tue Aug 29, 2006 3:59 pm

Ok. turns out that DRS stage has this problem. ODBC Enterprise stage does not have this problem. However, if there is timestamp column, it has to come in as a timestamp from the input, not some other type.

eze_ke · Post by **eze_ke** » Wed Aug 30, 2006 6:07 am

hey dude

i aslo came accross this but no one in this forum has replyed for that

let us know if u get any solution to this

iam able load with server Job but the parallel Job truncates the columns

emma · Post by **emma** » Wed Aug 30, 2006 7:58 am

Check the output field format.The paralel stages are more picky as the server stages.