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.
Your blogs are great.Are you also searching for cheap nursing writing company Check on our site. whatsapp us:+1-(951)-468-9855
ReplyDelete