Azure Blob Storage – How to loop through azure blobs using ForEachLoop Task

Home Page Forums FAQs – SSIS PowerPack Azure Blob Storage – How to loop through azure blobs using ForEachLoop Task

This topic contains 0 replies, has 1 voice, and was last updated by  ZappySys 6 years ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #390

    ZappySys
    Keymaster

    If you have to loop through Azure Storage Blobs to perform certain action then you may use Azure Storage Task. Perform the following steps to get list of objects from Azure Storage and Loop through item list.

    1. Drag and drop Azure Storage task from SSIS toolbox
    2. Configure task as below
      ssis-foreachloop-azure-storage-container
    3. Configure ForEachLoop task as below
      ssis-foreachloop-azure-storage-blobs-files
    4. Map foreach loop task variables to correct index
      ssis-foreachloop-azure-storage-blobs-files
    5. Run SSIS package
      ssis-foreachloop-azure-storage-container

     

Viewing 1 post (of 1 total)

The forum ‘FAQs – SSIS PowerPack’ is closed to new topics and replies.