Ole Db来源失败 [英] Ole Db source getting failed

问题描述

有疑问，

直到今天我的SSIS包工作正常或没有任何问题。 

Till today my SSIS package was working correctly or without any issue. 

我的SSIS包是使用OLEDB Sources拉取数据并转储到.txt文件，然后使用FTP连接将文件发送到FTP服务器，现在我可以拉取数据但是在拉动数据后PACKAGE也停止在OLE $上获得RED X标记b $ b DB来源。下面附有图片和错误。请建议。

My SSIS package is pulling the data using OLEDB Sources and dumping to .txt file then using FTP connection to send file to FTP Server, now I can able to pull the data but the PACKAGE is being stopped at after pulling the data also getting RED X mark on OLE DB Source. Below Image and error are attached. Please advice.

文件已创建，我可以打开它，也可以查看数据。

File is been created and I can open it and can see data too.

谢谢

推荐答案

您好Danny2426，

Hi Danny2426,

似乎所有错误中，以下错误是导致此问题的根本原因：

It seems that out of all errors, the following error is a root cause for the issue:

" ... 错误代码：0x80004005。

< span style =""> OLE DB记录可用。 来源："Microsoft SQL Server Native Client 11.0"  Hresult：0x80004005 描述："子查询返回的值超过1。当子查询遵循=，
！=，<，< =，>，> =或子查询用作表达式时，不允许这样做。"...""

"...Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."..."

所以它是数据相关的问题，这就是它之前没有表现出来的原因。

So it is data dependent issue and that's why it wasn't manifesting itself earlier.

你需要同时检查你的来源查询以及
来源 数据。

You need to check both your source query as well as your source data.

只需运行相同的查询在SSMS。

Just run the same query in SSMS.

这篇关于Ole Db来源失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！