Fix Redshift Copy ERROR: XX000: Mandatory url is not present in manifest file

If you are doing data transfer using SSIS Redshift Data Transfer task
and if you receive following error then most likely you have not specified folder in your target location.


Error: An error occurred with the following error message: "ERROR: XX000: Mandatory url is not present in manifest file.".

Solution: To fix this error change target folder location (On Target tab -> Staging Area Panel -> Stage folder) such a way so it includes bucket and some folder name after that too.

Invalid Path: mybucket/
Valid Path: mybucket/somefolder

How to fix Redshift Copy Error for SSIS Redshift Data Transfer task: "ERROR: XX000: Mandatory url is not present in manifest file.".

How to fix Redshift Copy Error for SSIS Redshift Data Transfer task: “ERROR: XX000: Mandatory url is not present in manifest file.”.

Posted in Redshift and tagged , , , , .