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.".](https://cdn.zappysys.com/blog/wp-content/uploads/2016/01/redshift-error-xx000-mandatory-url-is-not-present-in-manifest-file.png)
How to fix Redshift Copy Error for SSIS Redshift Data Transfer task: “ERROR: XX000: Mandatory url is not present in manifest file.”.