Is there a solution that doesn't require shelling out within Data Services that can download a zip file via SFTP and decompress the zip file prior to transform and load?
I created the file location, but had to use the copy_from_remote_system function to download the file. I passed the file location name and the name of the file and that allowed me to download a non structured file (non xls,flat file). As for decompressing the file, yes, there's no native function to decompress so I had to shell out and run a decompress command line utility to decompress the zip file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.