data getting trimmed

aschand · Post by **aschand** » Wed Jan 30, 2008 11:52 am

Can any one please help me with this issue

the data in the source for a column is '1234566777888' (stored as character)

but in the target table it is stored as '1234566777' only i.e; accepting only upto 10 characters

other columns with same data type are able to handle large values bigger than this.

this this one particular column has the issue.

no function is used here... but it is not able to load the whole value though the column datatype as size is Nvarchar(100)

thanks
aschand

paddu · Post by **paddu** » Wed Jan 30, 2008 12:24 pm

what is your source ???

all the values in this column have this issue or only few values ????

aschand · Post by **aschand** » Wed Jan 30, 2008 12:45 pm

thanks... it got solved

paddu · Post by **paddu** » Wed Jan 30, 2008 12:49 pm

then please mark this topic as resolved

VCInDSX · Post by **VCInDSX** » Wed Jan 30, 2008 1:10 pm

While closing the thread, if you could also throw some light on how you fixed this issue, it will be of help for "future" generations.

Cheers!!!