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.


  • 2
    If you have data in Data Extension then Data Extract is very straightforward. It could be something to do with your enhanced FTP setup. I would raise a case to Salesforce to resolve this
    – Maneesh
    Aug 24, 2017 at 17:39
  • @Maneesh the error is on the data extract and not file transfer. It has nothing to do with the SFTP at this point. Apr 14, 2019 at 17:25
  • Hi, did you find a solution to this? My setup looks exactly the same and I am getting the same unspecific error
    – Guest9875
    Sep 18, 2020 at 12:56

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.