Matt......Thank you very much! That was it. I upped the column # in the advanced properties of the flat file column and it worked!

If anyone in the thread was suggesting...

I have modified the column to every data type available and maxed them out. I have checked the source to see if there is anything there like an unwanted invisble...

Try the sting value I have posted and try and load it into sql 2005 into a default generic table column and see what you get. You may have hit...

OK before I do this can you tell me why it works in all other previous versions of sql including NT 4.0?

Thanks Jeff but I've done everything imaginable. It doesn't matter how wide you make it.

Wayne