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,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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,
Hi Jerome, can i check if you managed to fix this?? I am facing similar issue to execute python script in SSIS Linux