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 |
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
 Posted - 2009-04-27 : 18:04:21
|
This is the first time am doing using the Import/Export wizard in SSMS and I'm facing a problem.I have the data from 2 tables in 2 .txt files. I'm trying to import the data into the corresponding 2 tables in my database using a flat file source.The last column is a binary(1000) column. During the execution, it fails saying truncation has occurred.quote:
Text was truncated or one or more characters had no match in the target code page
I'm thinking this erro ris because the column is a binary(1000), but if u see the text data is has 2000 bytes corresponding to the binary(1000). can someone please let me know how to resolve this? |
|
|
|
|
|
Import Export Wizard in SSMS