Downloading files from Azure Blob Storage - Error: The given path's format is not supported

1
votes

I've just started working with Azure Blob Storage and I'm trying to download Blob Blocks to my local environment, without any success. the file names get copied, but no data is copied (i.e. the files are empty)

If I use the same settings with an upload task, then the files are copied.

The error I get from SSIS (SQL Server 2016 SP1 and VS 2015 professional) is:

Error: Download task has stopped with exception: The given path's format is not supported.

Below are the properties of the download and upload, any ideas anyone?

cheers, Anthony

Azure Blob Download Properties

Azure Blob Upload Properties

2
azuressis
I forgot to mention the local directory is set by a variable so is exactly the same for both processes – Anthony
We needed to recreate the BLOB storage container and all worked? – Anthony

2 Answers

0
votes

I tested both of these tasks, and my setup of each of the tasks look pretty much identical to yours as far as slashes and backslashes go for the LocalDirectory, BlobContainer, BlobDirectory, etc. I did notice you have some variation in capitalization (e.g. DELTA vs Delta), but I tested that as well, and it was not case sensitive. Because all of that looks perfect, I suspect there is an issue with permissions or the name of the files that it doesn't like.

0
votes

You probably need to escape the backslashes in the expression that sets the variable value used for LocalDirectory, like this: 

C:\\Temp\\Delta\\GoodsIn