无法从XML为任务Azure Blob下载任务创建任务.错误0x80070057参数正确 [英] Cannot create a task from xml for task Azure Blob Download Task. Error 0x80070057 the parameter is in correct
问题描述
我们已经实现了一个SSIS包，该包可以从Azure blob存储下载文件.当我们从本地开发箱执行时，该包起作用.但这在TEST环境中失败了.
We have implemented an SSIS package which downloads the file from Azure blob storage. The package works when we execute from local development box. But it's failing on TEST environment.
这在较早的本地环境和TEST环境中都有效.我们无法弄清最近出了什么问题.
This was working earlier both local and TEST environment. We couldn't figure out what went wrong recently.
有人可以在这里帮助我们吗?
Can somebody help us here?
以下是我们已安装的软件组件.
Following are the software components we have installed.
SQL Server版本:2016年SSDT:Microsoft SQL Server数据工具Visual Studio 2017服务功能包:适用于Azure(x64)的SQL Server 2016 Integration Services功能包Management Studio:Microsoft SQL Server Management Studio-17.9
SQL Server Version: 2016 SSDT : Microsoft SQL Server Data Tool Visual Studio 2017 Service Feature Pack: SQL Server 2016 Integration Services Feature Pack for Azure (x64) Management Studio: Microsoft SQL Server Management Studio - 17.9
以下是我们设置的属性.
Following are the properties we have setup.
组件:Azure Blob下载任务.属性:AzureStorageConnection.LocalDirectory:Blob容器:文件名
Component: Azure Blob Download Task. Properties: AzureStorageConnection. LocalDirectory: BlobContainer: FileName
以下是我们在执行上下文中看到的错误消息.
Following are the error message we are seeing in the execution context.
Azure Blob下载任务:错误:任务验证期间存在错误.
Azure Blob Download Task:Error: There were errors during task validation.
Azure Blob下载任务:错误:任务加载失败.此任务的联系信息为".
Azure Blob Download Task:Error: The task has failed to load. The contact information for this task is "".
Azure Blob上传任务:错误:无法加载任务"Azure Blob上传任务"，键入".此任务的联系信息为".
Azure Blob Upload Task:Error: Failed to load task "Azure Blob Upload Task", type "". The contact information for this task is "".
遍历记录:错误:无法通过XML为任务"Azure Blob上载任务"创建任务，键入"SSIS.ReplacementTask，{8B8C4D3B-F53C-4DCC-8D7D-6E197EE31125}"，原因是错误0x80070057参数为错误.".
Loop through records:Error: Cannot create a task from XML for task "Azure Blob Upload Task", type "SSIS.ReplacementTask, {8B8C4D3B-F53C-4DCC-8D7D-6E197EE31125}" due to error 0x80070057 "The parameter is incorrect.".
Azure Blob下载任务:错误:无法加载任务"Azure Blob下载任务"，键入".此任务的联系信息为".
Azure Blob Download Task:Error: Failed to load task "Azure Blob Download Task", type "". The contact information for this task is "".
循环浏览记录:错误:无法从XML为任务"Azure Blob下载任务"创建任务，键入"SSIS.ReplacementTask，{8B8C4D3B-F53C-4DCC-8D7D-6E197EE31125}"，由于错误0x80070057参数为错误.".
Loop through records:Error: Cannot create a task from XML for task "Azure Blob Download Task", type "SSIS.ReplacementTask, {8B8C4D3B-F53C-4DCC-8D7D-6E197EE31125}" due to error 0x80070057 "The parameter is incorrect.".
推荐答案
有关第一个错误，请参阅维护计划错误 https://social.msdn.microsoft.com/Forums/ie/zh-CN/0b57adfa-0872-4cd4-85d8-40bfaa520285/error-when-executing-ssis-package?forum=sqlintegrationservices
For the first error, please refer to Maintenance Plan Error https://blog.sqlauthority.com/2018/02/16/sql-server-maintenance-plan-error-cannot-create-task-xml-task-eue-error-0x80070057-parameter-incorrect-onpreexecute/ Error: The task with the name "Data Flow Task" https://social.msdn.microsoft.com/Forums/ie/en-US/0b57adfa-0872-4cd4-85d8-40bfaa520285/error-when-executing-ssis-package?forum=sqlintegrationservices
仅作说明:您是否可以尝试以下选项:1.尝试使用DTexce工具执行程序包，以检查此问题是否仍然存在.2.手动将Azure Blob任务注册到GAC.3.检查该帐户是否有权将文件上传到Azure.
Just for clarification : Have you could try following options: 1. Try using DTexce tool to execute the package to check if this issue persist. 2. Register the Azure Blob Task into GAC manually. 3. Check if the account has permission to upload file to Azure.
Azure Blob Download Task https://docs.microsoft.com/en-us/sql/integration-services/control-flow/azure-blob-download-task?view=sql-server-2017
请告知我们以上内容是否对您有帮助，或者您在此问题上需要进一步的帮助.
Kindly let us know if the above helps or you need further assistance on this issue.
这篇关于无法从XML为任务Azure Blob下载任务创建任务.错误0x80070057参数正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
