Page 1 of 1

data getting trimmed

Posted: Wed Jan 30, 2008 11:52 am
by aschand
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

Posted: Wed Jan 30, 2008 12:24 pm
by paddu
what is your source ???

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

Posted: Wed Jan 30, 2008 12:45 pm
by aschand
thanks... it got solved

Posted: Wed Jan 30, 2008 12:49 pm
by paddu
then please mark this topic as resolved :wink:

Posted: Wed Jan 30, 2008 1:10 pm
by VCInDSX
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!!!