none
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.

    Question

  • 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. 

    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 was trying to copy a pdf file and so configured the input file name as *.pdf. 
    Thursday, November 22, 2018 6:38 AM

All replies

  • Hello,

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

    https://docs.microsoft.com/en-us/sql/integration-services/control-flow/file-system-task?view=sql-server-2017#predefined-file-system-operations

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

    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:

    • 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.

    • 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.

    Monday, November 26, 2018 10:39 PM
    Moderator