[SalesForce] Data Extract of data extension to Enhanced FTP

I am trying to extract Contact Keys from a data extension so that I can load them back into the system to unsubscribe them. I am gathering these contact keys from multiple SQL Queries to different objects and putting them into the data extension below.

I am running into an issue where my Data Extract Activity is failing. I am running this from an Automation, which is configured as below.

Data Extract Activity for Extracting Unsubscribes

I have tried multiple different data extensions, and all of the three checkboxes but I have had no success.

My Data Extension looks like the following:

Data Extension Setup

The File Transfer setup

File Transfer Setup

And finally the FTP Setup

FTP Setup

The error i get is not helpful.

Error

Best Answer

In case it's useful for anyone else having this issue - to extract as a CSV, tick the 'Has Header Column' and leave others as false.

Related Topic