I am trying to BCP data from a 2005 to 2008 SQL database, on the 2008 sql e are using Nvarchar instead of varchar.
When i try to use the commando:
BCP xxx in x\xxx -T -n -S xxxxx
Then i get this fail error
SQLState = 22001, Native Error = 0 String data Right truncation.
I have then try to get a Error file from the BCP by using -e, then i got this: (se atach file)
When i look at the file i see it say that it is diffrence collum it fail on, so first i thought they could be diffrence on how many collums og Sorce/target.. but they are identical.. (just the Nvarchar)..
Have anyone idea what i could try.