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 |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2010-04-07 : 11:41:40
|
| Hi,The error message of running a SSIS in the job log file is:Error: 2010-04-07 10:45:25.27 Code: 0xC020901C Source: Data Flow Task Source - 'Summary$' [1] Description: There was an error with output column "The Sample Explanation" (15) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". End Error Error: 2010-04-07 10:45:25.27 Code: 0xC020902A Source: Data Flow Task Source - 'Summary$' [1] Description: The "output column " The Sample Explanation " (15)" failed because truncation occurred, and the truncation row disposition on "output column "The Explanation" (15)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2010-04-07 10:45:25.27 Code: 0xC0047038 Source: Da... The package execution fa... The step failed.I’ve set up a SSIS package to import data from Excel to SQL Server. The Excel has some columns with long text value (more than 255 char). After got this message, I changed the value of TypeGuessRows in registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet4.0\Engines\Excel to 0.Then, I restart the SQL Server Management Studio to run the job again, I got the SAME ERROR!Can someone tell me what else I can do to get ride of this Truncation Error from import data from Excel to SQL server 2005?Does Microsoft SQL team know about this? Any fix has been issued on this problem? Thanks. |
|
|
|
|
|
Truncation Error again