0

An import step of my automation fails. I tried to imitate that import manually and I realized that Salesforce does not continue the import when the file is empty. In my case, my file contains only the header and no rows.

But I do want to overwrite the destination Data Extension even when there are no rows. If the file is empty, I simply would like my Data Extension to be empty, too.

How can I let empty files count as import as well?

5

In order to do this, you will need to contact SFMC Support and request a business rule "Allow Blank File Processing" to be enabled on your instance.

This allows the import of empty files without halting the process. By default the settings in the backend force a stop on blank imports, but with this business rule enabled it is changed to continue.

  • I will do this! Thank you! So far, half of my development time for the SF account I am working on has gone to asking for permissions and checkboxes about which I had no idea. – Disasterkid Jul 11 at 14:28
  • 1
    I have created a support ticket now. I will come back and choose this an answer as soon as the SF support person confirms this. – Disasterkid Jul 11 at 14:36
  • Was SFMC support able to help you enabling this? – Rain Nov 7 at 12:43

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.