SSIS包在调试时立即取消 [英] SSIS Package Cancels instantly on Debug

问题描述

我有一个相当简单的SSIS包，我已使用它多次将制表符分隔的文件导入数据库中的单个表中.

I have a rather simple SSIS package that I've used many times to import a tab delimited file into a single table in a database.

我在程序包中附加了一个新的源文件，并尝试运行该程序包.

I attached a new source file to the package and attempted to run the package.

• 包开始
• cmd提示符短暂出现，然后消失[?！]
• 然后，该过程在平面文件源组件上退出. [??！]
• 输出显示如下:

SSIS包"C:\ Users ... \ Conversion \ LoadHistory.dtsx" 开始.

SSIS package "C:\Users...\Conversion\LoadHistory.dtsx" starting.

信息:将数据加载到旧版时为0x4004300A 数据库-测试，SSIS.管道:验证阶段已经开始.

Information: 0x4004300A at Load Data to Legacy Database - Test, SSIS.Pipeline: Validation phase is beginning.

信息:将数据加载到旧版数据库时为0x4004300A- 测试，SSIS.Pipeline:验证阶段正在开始.

Information: 0x4004300A at Load Data to Legacy Database - Test, SSIS.Pipeline: Validation phase is beginning.

信息: 将数据加载到旧版数据库-测试时为0x40043006， SSIS.Pipeline:准备执行阶段开始.信息: 将数据加载到旧版数据库-测试时为0x40043007， SSIS.Pipeline:预执行阶段正在开始.

Information: 0x40043006 at Load Data to Legacy Database - Test, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Load Data to Legacy Database - Test, SSIS.Pipeline: Pre-Execute phase is beginning.

信息:0x402090DC 在将数据加载到旧版数据库时-测试，平面文件源 [14]:文件处理 "C:\ Users ... \ Conversion \ Production \ Historicals \ Source_2341.txt"已启动.

Information: 0x402090DC at Load Data to Legacy Database - Test, Flat File Source [14]: The processing of file "C:\Users...\Conversion\Production\Historicals\Source_2341.txt" has started.

信息:负载时为0x4004300C 数据到旧版数据库-测试，SSIS.管道:执行 阶段开始了.

Information: 0x4004300C at Load Data to Legacy Database - Test, SSIS.Pipeline: Execute phase is beginning.

SSIS包"C:\ Users ... \ Conversion \ LoadHistory.dtsx" 已完成:已取消.

SSIS package "C:\Users...\Conversion\LoadHistory.dtsx" finished: Canceled.

程序"[4380] DtsDebugHost.exe:DTS"具有 退出，代码为0(0x0).

The program '[4380] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

该文件似乎符合我期望的格式规范.我唯一能想到的是该文件最初被编码为UCS-2 Little Endian，并且我们期望使用UTF-8或ANSI格式.我使用Notepad ++将文件重新编码为UTF-8，结果文件通过了最初的元数据检查，因此我必须假定已解决该问题.

The file appears to adhere to the format specs I am expecting. The only concern I can think of is that the file originally was encoded as UCS-2 Little Endian and we are expecting a UTF-8 or ANSI format. I used Notepad++ to re-encode the file as UTF-8 and the file passed the initial meta-data checks as a result, so I have to assume that is resolved.

我不确定是什么原因导致包裹自动取消.

I am not sure what could be causing the package to automatically cancel.

以前有没有人经历过?

推荐答案

我发现了问题.毕竟归咎于该文件被用作源文件.通过元数据检查的UTF-8格式似乎有问题.我将文件转换为ANSI格式，如在黑暗中拍摄，并且能够正常导入文件而没有上述异常.

I found the issue. It appears the file being used as a source was to blame afterall. The UTF-8 format, while passing the meta-data check, appears to be at fault. I converted the file to ANSI format, as a shot in the dark, and was able to import the file normally without the above anomalies.

但是我不确定为什么打开命令提示符.

I am not sure as to why command prompt was opening however.

感谢您的答复

这篇关于SSIS包在调试时立即取消的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！