Menu

Error on 7za when called from C# script in SSIS package on Linux

Help
2018-10-18
2022-01-14
  • Jerome Patterson

    We have created an SSIS package with an Execute Script Task that dynamically builds the paths/arguments required as it loops through multiple files and unzips to extract a single file. This works perfectly on Windows with 7za.exe. And it works when we manually execute on Linux via the command line. For example:

    /usr/libexec/p7zip/7za -y x /data00/file.zip -o/data00/ ap*.csv -r

    When we call it from the SSIS package via the C# script it responds with the following:

    Error: 2018-10-16 18:24:02.90
    Code: 0x00000000
    Source: Unzip SCG 7Zip Error
    Description: The specified executable is not a valid application for this OS platform.
    End Error

    File info for 7za follows and everything is 64-bit.

    Any ideas?

    7za: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.32, BuildID[sha1]=db4a087d4a29e1f28ac66bb11fc99385093b6c14, stripped

    7-Zip (a) [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
    p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,8 CPUs Intel(R) Xeon(R) CPU E5-2695 v3 @ 2.30GHz (306F2),ASM,AES-NI)

    Thanks,

     
  • Shanthini

    Shanthini - 2022-01-14

    Hi Jerome, can i check if you managed to fix this?? I am facing similar issue to execute python script in SSIS Linux

     

Log in to post a comment.