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