SQL Server Flexible File Task - SSIS - Unable to delete from Azure Blob Storage

rn0zuynd  于 2023-06-04  发布在  其他
关注(0)|答案(1)|浏览(217)

I am able to copy files from an azure blob storage account not problem however once downloaded I want to delete them from storage.

Whenever I setup a flexible file task and set delete I get the the following error:

'SourceFolderPath' is not specified. I set this as a variable within the flexible file task and then try to re-run but then receive an error 'specified folderPath' does not exist.

Whatever combination I try I am unable to get this to work.

Anyone had a similar issue with SSIS ?

For something that should be so simple I am unable to get this to work.

I am able to copy files from an azure blob storage account not problem however once downloaded I want to delete them from storage.

mv1qrgav

mv1qrgav1#

I had a similar problem. For a delete, do not use sourcefilename and sourcefolderpath . Instead, use filename and folderpath . The expression for the folderpath must be followed by a / .

相关问题