Hey everyone, Geon back from the dead with another SQL Something!
Today we take a peek at a very, *very* annoying and very old issue with importing data into a SQL Database. This problem occurs when using either the Import/Export Wizard or SSIS.
The issue can take a couple forms:
- "Text was truncated or one or more characters had no match in the target code page."
- "A truncation error occurred on the specified object of the specified component."
- Etc.
Now you may think "Well, obviously it's probably your column lengths in the destination, so just increase that.".
Well, what if your destination columns are maxed out? What if it wasn't the destination?
 |
| I'd believe you to be honest... |
