I am trying to export tracking extracts from SFMC to FTP, and then import these tracking extracts in to data extensions for consolidation and in order to perform queries on this data.
I have created an automation that:
- Data Extract for Tracking data - successful
- File Transfer for moving the Extract from Safehouse to FTP Export folder - sucessful
- File Transfer to move the Extract from FTP Export folder to FTP Import folder (prepare for import to SFMC) - successful
- Import File to move Extract from FTP Import folder to data extension in SFMC - failed
When i try to open the Extract file in order to confirm column headings for mapping I am unable to - i have an error message that the file cannot be opened and that it is corrupt.
How do i resolve this for a successful automation for all 4 steps?