SSIS中的Azure数据湖存储文件系统任务失败，并出现错误:任务上的Execute方法返回了错误代码0x80131537(输入字符串的格式不正确.). Execute方法必须成功，并使用"out"指示结果.范围. [英] Azure Data Lake Store File System Task in SSIS fails with error: The Execute method on the task returned error code 0x80131537 (Input string was not in a correct format.). The Execute method must succeed, and indicate the result using an "out" parameter.

问题描述

我正在尝试将文件从本地文件夹复制到Azure Data Lake Storage.与ADLS的测试连接在连接管理器中成功完成.但是，当我执行复制文件任务时，它失败并显示以下错误消息.

I am trying to copy files from a local folder to Azure Data Lake Storage. The test connection to ADLS succeeded in the connection manager. However when I execute copy file task, it fails with the below error message. 

任务上的Execute方法返回错误代码0x80131537(输入字符串的格式不正确.). Execute方法必须成功，并使用"out"指示结果.参数.

The Execute method on the task returned error code 0x80131537 (Input string was not in a correct format.). The Execute method must succeed, and indicate the result using an "out" parameter.

推荐答案

您好，

我认为文件系统任务不支持您使用通配符的方式.在这里看看:

I don't believe the File System Task supports the wildcard the way you are using it.  Take a look here:

请注意底部的内容，以获取有关如何实现所需内容的指南:

Make note of the section at the bottom for guidance on how to achieve what you are looking for:

文件系统任务在单个文件或目录上运行.因此，此任务不支持使用通配符对多个文件执行相同的操作.要使文件系统任务在多个文件或目录上重复操作， 将文件系统任务放入Foreach循环容器中，如以下步骤所述:

The File System task operates on a single file or directory. Therefore, this task does not support the use of wildcard characters to perform the same operation on multiple files. To have the File System task repeat an operation on multiple files or directories, put the File System task in a Foreach Loop container, as described in the following steps:

• 配置Foreach循环容器  收藏在"Foreach循环编辑器"页面上，将枚举器设置为 Foreach文件 枚举器  ;，并输入通配符表达式作为文件的枚举器配置.在Foreach循环编辑器的变量映射页面上，映射一个变量 您想用来一次将一个文件名传递给文件系统"任务.

• Configure the Foreach Loop container On the Collection page of the Foreach Loop Editor, set the enumerator to Foreach File Enumerator and enter the wildcard expression as the enumerator configuration for Files. On the Variable Mappings page of the Foreach Loop Editor, map a variable that you want to use to pass the file names one at a time to the File System task.

添加并配置文件系统任务 将文件系统任务添加到Foreach循环容器.在文件系统任务编辑器的常规页面上，设置 SourceVariable  或 DestinationVariable  属性 到您在Foreach循环容器中定义的变量.

Add and configure a File System task Add a File System task to the Foreach Loop container. On the General page of the File System Task Editor, set the SourceVariable or DestinationVariable property to the variable that you defined in the Foreach Loop container.

这篇关于SSIS中的Azure数据湖存储文件系统任务失败，并出现错误:任务上的Execute方法返回了错误代码0x80131537(输入字符串的格式不正确.). Execute方法必须成功，并使用"out"指示结果.范围.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！