使用 SSIS 的源文件的数据流任务错误

发布于 2025-01-18 06:51:27 字数 1698 浏览 1 评论 0原文

从平面文件 (.csv) 导入数据是我的源连接，OLE DB 是目标时，我收到以下错误。

SSIS 包“C:\Users\Documents\Visual Studio 2010\Projects\Final\Final\Package.dtsx”开始。信息： 0x4004300A 位于数据流任务，SSIS.Pipeline：验证阶段为开始。信息：数据流任务中的 0x4004300A，SSIS.Pipeline：验证阶段即将开始。警告：数据流任务处的 0x80049304， SSIS.Pipeline：警告：无法打开全局共享内存与性能DLL通信；数据流性能计数器是无法使用。要解决此问题，请以管理员身份运行此软件包，或者在系统的控制台上。信息：数据流任务处的0x40043006， SSIS.Pipeline：准备执行阶段正在开始。信息： 0x40043007 位于数据流任务，SSIS.Pipeline：预执行阶段是开始。信息：数据流任务中的 0x402090DC，平面文件源 [2]：文件“D:\Badger\company334563_checkins.csv”的处理已经开始了。信息：数据流任务中的 0x4004300C，SSIS.Pipeline：执行阶段开始。错误：数据流任务中的 0xC02020A1，平坦文件源[2]：数据转换失败。数据转换为 “后续”列返回状态值 4 和状态文本“文本为被截断或者一个或多个字符在目标代码中不匹配页。”。错误：数据流任务中的 0xC020902A，平面文件源 [2]： “平面文件源.输出[平面文件源 Output].Columns[Follow up]" 由于发生截断而失败，并且 “Flat File Source.Outputs[Flat File”上的截断行配置源输出].Columns[Follow up]”指定截断失败。指定对象的指定对象发生截断错误成分。错误：数据流任务、平面文件源中的 0xC0202092 [2]：处理文件时发生错误数据行 2 上的“D:\Badger\company334563_checkins.csv”。错误： 0xC0047038 位于数据流任务，SSIS.Pipeline：SSIS 错误代码 DTS_E_PRIMEOUTPUTFAILED。平面文件源上的 PrimeOutput 方法返回错误代码 0xC0202092。组件返回失败代码当管道引擎调用 PrimeOutput() 时。的含义故障代码由组件定义，但错误是致命的并且管道停止执行。可能会发布错误消息在此之前提供有关失败的更多信息。信息： 0x40043008 位于数据流任务，SSIS.Pipeline：执行后阶段为开始。信息：数据流任务中的 0x402090DD，平面文件源 [2]：文件“D:\Badger\company334563_checkins.csv”的处理已经结束了。信息：数据流任务中的 0x4004300B，SSIS.Pipeline： “OLE DB 目标”写入了 0 行。信息：0x40043009 位于数据处流任务，SSIS.Pipeline：清理阶段正在开始。任务失败：数据流任务警告：0x80019002 位于包：SSIS 警告代码 DTS_W_MAXIMUMERRORCOUNTREACHED。 Execution方法成功了，但是提出的错误数量 (4) 达到允许的最大数量 (1)；导致失败。当错误数量达到 MaximumErrorCount 中指定的数字。改变 MaximumErrorCount 或修复错误。 SSIS包 “C：\用户\文档\Visual Studio 2010\Projects\Final\Final\Package.dtsx”完成：失败。

我创建了 SSIS 包以使用 OLE DB 目标将数据从平面文件导入到 SQL DB。

原文

I'm getting below error while importing data from flat file(.csv) is my source connection and OLE DB is the destination.

SSIS package "C:\Users\Documents\Visual Studio
2010\Projects\Final\Final\Package.dtsx" starting. Information:
0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is
beginning. Information: 0x4004300A at Data Flow Task, SSIS.Pipeline:
Validation phase is beginning. Warning: 0x80049304 at Data Flow Task,
SSIS.Pipeline: Warning: Could not open global shared memory to
communicate with performance DLL; data flow performance counters are
not available. To resolve, run this package as an administrator, or
on the system's console. Information: 0x40043006 at Data Flow Task,
SSIS.Pipeline: Prepare for Execute phase is beginning. Information:
0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is
beginning. Information: 0x402090DC at Data Flow Task, Flat File Source
[2]: The processing of file "D:\Badger\company334563_checkins.csv"
has started. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline:
Execute phase is beginning. Error: 0xC02020A1 at Data Flow Task, Flat
File Source [2]: Data conversion failed. The data conversion for
column "Follow up" 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 [2]:
The "Flat File Source.Outputs[Flat File Source
Output].Columns[Follow up]" failed because truncation occurred, and
the truncation row disposition on "Flat File Source.Outputs[Flat File
Source Output].Columns[Follow up]" 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
[2]: An error occurred while processing file
"D:\Badger\company334563_checkins.csv" on data row 2. Error:
0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Flat File Source
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. There may be error messages posted
before this with more information about the failure. Information:
0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is
beginning. Information: 0x402090DD at Data Flow Task, Flat File Source
[2]: The processing of file "D:\Badger\company334563_checkins.csv"
has ended. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline:
"OLE DB Destination" wrote 0 rows. Information: 0x40043009 at Data
Flow Task, SSIS.Pipeline: Cleanup phase is beginning. Task failed:
Data Flow Task Warning: 0x80019002 at Package: SSIS Warning Code
DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but
the number of errors raised (4) 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
"C:\Users\Documents\Visual Studio
2010\Projects\Final\Final\Package.dtsx" finished: Failure.