azure - SSIS 下载 Azure Blob 连接错误

Question

我很高兴能够参与一个 SSIS 项目，该项目(希望)能够部署到数据工厂。在设置 SSIS 作业时，我添加了一个从 Azure Blob 存储下载文件的步骤。在控制流中添加 Azure Blob 下载任务并输入存储配置(测试成功)后，出现以下错误:

SSIS package "C:\....\Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC001000E at Package: The connection "{27A6966C-8398-4C75-84C3-6007B96EEED4}" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error: 0xC001000E at Package: The connection "{27A6966C-8398-4C75-84C3-6007B96EEED4}" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error: 0xC001000E at Package: The connection "{27A6966C-8398-4C75-84C3-6007B96EEED4}" is not found. This error is thrown by Connections collection when the specific connection element is not found.
Error: 0xC0024102 at Azure Blob Download Task: The Validate method on the task failed, and returned error code 0x80131500 (The connection "{27A6966C-8398-4C75-84C3-6007B96EEED4}" is not found. This error is thrown by Connections collection when the specific connection element is not found.
). The Validate method must succeed and indicate the result using an "out" parameter.
Error: 0xC0024107 at Azure Blob Download Task: There were errors during task validation.
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (10) 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:\....Package.dtsx" finished: Failure.
The program '[18968] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

我已确认此处的 GUID 确实指向 XML 中的 Azure Blob 连接。我已经在几台电脑上重现了这个问题，并且删除并重新创建了连接和下载 Blob 任务数十次。 我不确定如何解决或获取有关该问题的更多信息。无论如何，在 Debug模式下启动后很快就会弹出此错误 - 在此错误之前仅运行了一些预验证(成功)。任何帮助表示赞赏。谢谢!

Answer 1

我最终完全卸载了 Visual Studio 和 SSDT 以及 Azure 功能包的所有实例。然后，在重新安装这些软件实例之后，我在 SSIS 中的 blob 功能就可以工作了。