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...ConversionLoadHistory.dtsx"开始.
SSIS package "C:Users...ConversionLoadHistory.dtsx" starting.
信息:0x4004300A 在将数据加载到旧版时数据库 - 测试、SSIS.Pipeline:验证阶段开始.
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...ConversionProductionHistoricalsSource_2341.txt"已启动.
Information: 0x402090DC at Load Data to Legacy Database - Test, Flat File Source [14]: The processing of file "C:Users...ConversionProductionHistoricalsSource_2341.txt" has started.
信息:加载时为 0x4004300C数据到旧数据库 - 测试，SSIS.Pipeline:执行阶段开始.
Information: 0x4004300C at Load Data to Legacy Database - Test, SSIS.Pipeline: Execute phase is beginning.
SSIS 包C:Users...ConversionLoadHistory.dtsx"完成:取消.
程序[4380] DtsDebugHost.exe: DTS"有以代码 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.
有人遇到过这种情况吗?
Has anyone experienced this before?
推荐答案
我发现了这个问题.看来被用作来源的文件毕竟是罪魁祸首.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屋！
