data getting trimmed
Posted: 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
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