Azure Blob Download Task error

Hello Raj D,

Greetings! Welcome to Microsoft Q&A Platform.

I understand that you are encountering issue in downloading the blob storage and getting the error message as Download task has stopped with exception: The given path's format is not supported.

To add an Azure Blob Download Task, drag-drop it to the SSIS Designer, and double-click or right-click and click Edit to see the following Azure Blob Download Task Editor dialog box.

The Azure Blob Download Task is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure.

Ensure that the path you’re using is correctly formatted for your operating system. For example, Windows paths should use backslashes () while Unix-based systems use forward slashes (/). Avoid using invalid characters in the path.

Windows has a maximum path length of 260 characters. If your path exceeds this limit, you might encounter this error.

Try using absolute paths instead of relative paths. This can help avoid issues where the relative path might not be correctly resolved.

If your path includes special characters, make sure they have properly escaped.

Ensure there are no trailing spaces in the path, as these can cause the format to be considered invalid.

Set a breakpoint and inspect the value of the path variable before the download task is executed. This can help you identify any issues with the path format.

Hope this answer helps! please let us know if you have any further queries. I’m happy to assist you further.

Please "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.