<@U04S8PLJWMT> I'm trying to ingest Excel files us...
# ask-ai
p
@kapa.ai I'm trying to ingest Excel files using SFTP Bulk connector to GCS bucket. I'm getting
Destination does not support file transfers, but source requires it
How can this issue be solved?
k
You’re running into two separate limitations at once: 1. SFTP Bulk → GCS with file transfers is not supported File-transfer mode (the “Copy raw files” / unstructured files feature) is only supported from a small set of sources to S3 as the destination. Initially it was introduced specifically for “SFTP Bulk → S3” and not for GCS or other destinations.[[Airbyte 1.2 release](https://docs.airbyte.com/release_notes/v-1.2); [Sync files and records](https://docs.airbyte.com/platform/using-airbyte/sync-files-and-records#which-connectors-support-file-transfers)] The platform docs list the connectors that support file transfers: - Sources: Zendesk Support, S3, Sharepoint, Google Drive, SFTP Bulk - Destination: S3 only.[[Sync files and records](https://docs.airbyte.com/platform/using-airbyte/sync-files-and-records#which-connectors-support-file-transfers)] When you configure SFTP Bulk in file-transfer mode and point it to a destination that does not support file transfers (like GCS), the platform throws exactly the error you’re seeing:
Destination does not support file transfers, but source requires it
. So there is no supported way (per current docs) to use SFTP Bulk in file-transfer mode directly to GCS. 2. SFTP Bulk’s supported file formats The SFTP Bulk connector parses file contents for these formats: Avro, CSV, JSONL, Parquet, and “Document File Type Format”.[[SFTP Bulk supported streams](https://docs.airbyte.com/integrations/sources/sftp-bulk#supported-streams)] Excel is not listed as a supported structured format for SFTP Bulk. By contrast, the generic File source supports Excel when reading from HTTPS, GCS, S3, SFTP, etc., but that’s a different connector.[[File storage providers](https://docs.airbyte.com/integrations/sources/file#storage-providers)] --- ### What you can do instead Based strictly on the docs: - If you need raw file transfer (including compressed/unstructured) from SFTP Bulk: - Use S3 as the destination, and choose the Copy raw files delivery method when configuring the connection.[[Sync files and records](https://docs.airbyte.com/platform/using-airbyte/sync-files-and-records#unstructuredfile-based-sources)] - GCS as a destination for file-transfer mode is not documented/supported, so the error cannot be “fixed” for GCS without a platform change. - If you specifically need Excel → GCS: - There is no documentation showing that SFTP Bulk parses Excel; only Avro/CSV/JSONL/Parquet/Document are listed.[[SFTP Bulk supported streams](https://docs.airbyte.com/integrations/sources/sftp-bulk#supported-streams)] - Excel is supported as a file format for some file-based connectors (e.g., the File source and GCS source), but those assume the files are already in supported storage like GCS/S3/SFTP, and do not go through SFTP Bulk.[[File storage providers](https://docs.airbyte.com/integrations/sources/file#storage-providers); [GCS supported streams](https://docs.airbyte.com/integrations/sources/gcs#supported-streams)] Given the current documented capabilities, there is no supported configuration that: - Uses SFTP Bulk as the source, - Targets GCS as the destination, - And uses file-transfer mode (which SFTP Bulk requires when copying raw files). To resolve the current error, you would need to: 1. Either switch the destination to S3 and use file-transfer mode with SFTP Bulk, 2. Or avoid using file-transfer mode (where possible) and instead use connectors that natively support Excel and GCS (e.g., place the Excel files in GCS first and then use the GCS or File source to ingest them into your analytical destination). The knowledge sources do not provide any documented workaround to enable file transfers to GCS or to make SFTP Bulk parse Excel directly, so anything beyond the options above would be outside what’s officially documented.