The error is saying that you are trying to take a source column with a length of 259 and put the data in a destination column with a length of 256.

If possible, try and cast it as 256 in SQL and see if it works, it will complain if there is any data wider than 256 in which case you will have to up your destination column width to 259.

~PD