posted
03 October 2021
We have a number of import / export packages involving moving data between SFTP, GSheet & HubSpot. While we can control the order of execution within a package, we can't do that across. E.g. We cannot create a flow where we import from CSV to GSheet, then upon completion of that, export from the GSheet back to CSV. The only way it seems to we can set this type of operations up is using Control Flow stringing together Data Flows. But Data Flow do not allow for SFTP as a source/destination.
Is there a way around this so we can sequence these imports/exports. Right now, we hae them timed, but we do run a risk of one pacakge not being done before the next one begins based on time schedule.
