How to Delete or Copy Files from Azure Blob Storage by Using SSIS Package SSIS Tutorial 2021

 Issue : How to Delete or Copy Files from Azure Blob Storage by Using SSIS Package SSIS Tutorial 2021.

In this blog we are going to learn how to delete files from azure blob storage by using SSIS package,
so in this case what we are going our SSIS package running on our on premises server and the we need to
may be upload the data to some blob storage also delete some files which are sitting in azure blob storage. 

For delete files open visual studio and click on File + New + Project select integration services project and name the project, in my case it is (DeleteFilesOnAzureBlob). then click ok.

Fig-1: Create new SSIS project in visual studio 2017.

Click & drag flexible azure task from azure feature pack, double click on that and fill the tabs which are 1. Basic, 2. Operation, 3. Connection, fill all the required information and click ok and execute Task.

Fig-2: Configure flexible azure task for delete files


Click on the progress and read the progress reoport it will shown the number of deleted files.


Fig-3: Progress report of the flexible azure task

For Copy files open visual studio & click on File + New + Project select integration services project and name the project, in my case it is (CopyFilesOnAzureBlob). then click ok., then click & drag flexible azure task from azure feature pack, double click on that and fill the tabs which are 1. Basic, 2. Operation, 3. Source, 4. Destination, fill all the required information and click ok and execute Task.

Fig-4: Configure flexible azure task for copy files

Go to your output folder and see your copied files there.

Fig-5: Output folder for copied files.


Video Demo: How to Delete or Copy Files from Azure Blob Storage by Using SSIS Package SSIS Tutorial 2021


No comments:

Post a Comment