ssis package error

liyihongcug

将经过处理的文本文件导入sqlserver2005
只能用ssis

SSIS package \"dat_addr.dtsx\" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x802092A7 at Data Flow Task, OLE DB Destination [27]: Truncation may occur due to inserting data from data flow column \"Column 0\" with a length of 50 to database column \"rpt_id\" with a length of 24.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x802092A7 at Data Flow Task, OLE DB Destination [27]: Truncation may occur due to inserting data from data flow column \"Column 0\" with a length of 50 to database column \"rpt_id\" with a length of 24.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file \"C:\\dat_new\\dat_addr.txt\" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Error: 0xC02020A1 at Data Flow Task, Flat File Source [1]: Data conversion failed. The data conversion for column \"Column 1\" returned status value 4 and status text \"Text was truncated or one or more characters had no match in the target code page.\".
Error: 0xC020902A at Data Flow Task, Flat File Source [1]: The \"output column \"Column 1\" (21)\" failed because truncation occurred, and the truncation row disposition on \"output column \"Column 1\" (21)\" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Error: 0xC0202092 at Data Flow Task, Flat File Source [1]: An error occurred while processing file \"C:\\dat_new\\dat_addr.txt\" on data row 3332.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component \"Flat File Source\" (1) returned error code 0xC0202092.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread \"SourceThread0\" has exited with error code 0xC0047038.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread \"WorkThread0\" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread \"WorkThread0\" has exited with error code 0xC0047039.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Source [1]: The processing of file \"C:\\dat_new\\dat_addr.txt\" has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: \"component \"OLE DB Destination\" (27)\" wrote 0 rows.
Task failed: Data Flow Task
Warning: 0x80019002 at dat_addr: The Execution method succeeded, but the number of errors raised (7) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package \"dat_addr.dtsx\" finished: Failure.

是否表示文本文件第27行发生未知错误

liyihongcug

发现是文本框text 引起的故障
看能够转换错误

liyihongcug

新问题：：
SSIS package \"dat_job.dtsx\" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x802092A7 at Data Flow Task, OLE DB Destination [30]: Truncation may occur due to inserting data from data flow column \"Column 0\" with a length of 50 to database column \"rpt_id\" with a length of 24.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Warning: 0x802092A7 at Data Flow Task, OLE DB Destination [30]: Truncation may occur due to inserting data from data flow column \"Column 0\" with a length of 50 to database column \"rpt_id\" with a length of 24.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file \"C:\\dat_new\\dat_job.txt\" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Error: 0xC02020A1 at Data Flow Task, Flat File Source [1]: Data conversion failed. The data conversion for column \"Column 1\" returned status value 4 and status text \"Text was truncated or one or more characters had no match in the target code page.\".
Error: 0xC020902A at Data Flow Task, Flat File Source [1]: The \"output column \"Column 1\" (21)\" failed because truncation occurred, and the truncation row disposition on \"output column \"Column 1\" (21)\" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Error: 0xC0202092 at Data Flow Task, Flat File Source [1]: An error occurred while processing file \"C:\\dat_new\\dat_job.txt\" on data row 26448.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component \"Flat File Source\" (1) returned error code 0xC0202092.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread \"SourceThread0\" has exited with error code 0xC0047038.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread \"WorkThread0\" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread \"WorkThread0\" has exited with error code 0xC0047039.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Source [1]: The processing of file \"C:\\dat_new\\dat_job.txt\" has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: \"component \"OLE DB Destination\" (30)\" wrote 9830 rows.
Task failed: Data Flow Task
Warning: 0x80019002 at dat_job: The Execution method succeeded, but the number of errors raised (7) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package \"dat_job.dtsx\" finished: Failure.