Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I am using Data Extract -> File Transfer -> Import via an automation to upload my synchronized data extensions to All Subscribers in Marketing Cloud.
Currently everything seems to work fine, however I am interested to know is there any limitations such as row count, data size, etc via importing from enhanced FTP?
File Imports are the most tried and true method of getting large amounts of data into SMFC. As for limitations -- most of the issues I've seen with imports haven't been with size or row counts -- it's been with bad data, like extra CR/LFs, bad delimiters or improper text qualification. Importing structured data like XML is possible, but not recommended. The functionality is too limited.
As for file size, I've worked in some accounts that import 3 gigabyte files every day.
If you're having issues with File Imports and you have an older account (more than 3 years old), check with SFMC Support to see if you have the latest version of the importer.
There are also several business rules that modify file import behavior -- like importing empty files without error, etc.
There are also several options for handling encrypted files, the Safehouse, and file-drop triggered automations.
