I wrote my own C# code to do the data migration from .csv file to MS CRM 4.0 via CRM Webservices.
Now when I tried to migrate data into the annotation entity's NoteText attribute, I got Parsing error: “Row is too long to import". The problem is the input text field contains more than 4000 characters and the parser doesn't like it. 4000 char is the limitation a nvarchar field in MS SQL Server but the NoteText attribute is a nvarchar(Max) type.
I found a solution: http://blogs.msdn.com/crm/archive/2008/09/02/data-migration-manager-tips-and-tricks.aspx
That solution bypasses the parsing limitation when using DMM(Data Migration Manager). However for some reason I really need to data migrate using SDK directly talk to the CRM webservices. So the question is come down to how to tell the CRM webservices to stop apply the 4000 char limitation rule when I importing using SDK.
Thanks!!!