sql-server - 升级 Visual Studio 后 SSIS 包无法运行

Question

我的一个 SSIS 项目有问题。一年多前我开发了这个包，它运行完美，直到我升级了 Visual Studio。原始项目在 VS Shell 2010 中。我的新版本是 VS 2017 Pro。

设置非常基本。我通过 SQLite3 ODBC 驱动程序使用 ADO.NET 源从数据库文件 (.db) 中提取数据。它提取每个表并将数据插入到 MS SQL Server 表中。目标服务器版本设置为 SQL Server 2012。它使用密码加密。当我说我试图执行包时，我说的是 VS。

这是问题所在：在执行时，包将执行启动进程的 SQL 语句，当我到达从数据库中提取的第一个数据流时，命令窗口会短暂闪烁并关闭。包错误完成：

[Assignments [290]] Error: The Assignments was unable to process the data. Object reference not set to an instance of an object.
[Resources [801]] Error: The Resources was unable to process the data. Object reference not set to an instance of an object.
[Entries [657]] Error: The Entries was unable to process the data. Object reference not set to an instance of an object.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Resources returned error code 0xC02090F5.  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.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Entries returned error code 0xC02090F5.  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.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Assignments returned error code 0xC02090F5.  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.
[Projects [711]] Error: The error "Column data type 66203200 is not supported by the PipelineBuffer class." occurred while processing "Projects.Outputs[ADO NET Source Output].Columns[project_id]".
[Projects [711]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Projects" failed because error code 0x80131600 occurred, and the error row disposition on "Projects.Outputs[ADO NET Source Output].Columns[project_id]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
[Projects [711]] Error: The Projects was unable to process the data. Pipeline component has returned HRESULT error code 0xC0209029 from a method call.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on Projects returned error code 0xC02090F5.  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.

奇怪的是，只有数据流中的一些数据源存在问题 (3/6)。

这是我更改/厌倦的列表：
- 我使用 VS 2017 重建了整个解决方案（这工作了大约 1 周）
- 我测试了 ODBC 驱动程序（32/64）。都成功了。
- 我第一次打开时升级了项目。
- 我重新创建了源连接。
- 我删除并重新创建了数据流。- 我删除并重新创建了每个数据源。（数据预览成功）
- 我将 VS 更新为最新的补丁。

没有任何效果！任何输入都会有所帮助。

标签： sql-servervisual-studiossis