>>I checked char fields & none has any '~' tilde in it.
>>checked NULLDISPLAY as well.
>>Still same ERROR, or bulkInsert. String too long error is shown.
>>
>>If I allow nulls for all char fields then the upsizing is successful.
>>allow nulls for any 1 or few char fields is not successful, only selecting all char fields avoids the error.
>You may be able to do a 'trace-back' based on the data uploaded to SQL Server by enforcing the NOT NULL rule on the fields one at a time. This will hopefully, point you to the field or fields that would have failed during the upsizing as SQL server will not allow the table changes if it breaks the constraint.
I was able to work around the error by turning off "bulk insert". The code for bulk insert may have some limitation which was causing the error.
By turning off "bulk insert", the database upsize was successful on each attempt.
Thanks, your suggestions helped me in experimenting with it, otherwise I would have given up on using the upsizing wizard & wasted a lot of time on doing it all manually by writing scripts.
Aman
-------
Lets fly away to the Land where there is Love & Peace