Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2008-03-07 : 08:57:28
|
| hi when I try to export data to a fixed width txt file I get the following error:Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "postcode" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".even though my sql for postcode is LEFT(postcode,8) and the field length is 8 !do you now why ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-07 : 09:21:14
|
| Try thishttp://weblog.vb-tech.com/nick/archive/2006/08/24/1742.aspx |
 |
|
|
|
|
|
error with fixed widths