3

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

Improve this question
3
  • 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
    Commented 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.
    – Jackson Chen
    Commented 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
    Commented Sep 18, 2020 at 12:56

1 Answer 1

Reset to default
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.

Improve this answer

You must log in to answer this question.

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