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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .