DSXchange

Trying to write source column Varchar(max) to target Varchar(max) in SQL Server. There is error stating mismatch column length/size with truncation of data...

I have tried writing into SQL using LongVarchar (setting array sixe 1) but the error persists. Some incoming rows exceed the 8000 character length, so it's preferred we leave the character length to 'blank'.

Thanks in advance.

its been a while but if I remember this right, sql server wanted nvarchar not long varchar for long strings. try that?

Yes - tried that...actually, that would further restrict the allowable size...

Try: Set the jobs corresponding column type to LONGVARCHAR to a length of zero along with the Array size property to a value of 1.

After the field is loaded into a Varchar max column...the data seems to be truncated (missing) - no more runtime error...but the data is missing...

See my posts elsewhere about MAX_FETCH_BUFF.