Azure File share sub directory enumerator using SSIS foreachloop

Khatri, Ashish 96 Reputation points
2021-02-10T05:54:18.29+00:00

Hello All,

I have a SSIS package with For each loop that enumerate on path like C:\folder\folder1\folder2\folder3 and reading all the files from folder3 with search pattern .xlsx and now the same structure is created on azure file share \storagename\folder\folder1\folder2\folder3 when SSIS package deployed to azure sql Catalog and running same using data factory is not reading the files available at folder3 and saying that foreachloop enumerate empty as I am using UNC path for folder3.

please help me to read files from azure file share subdirectory using SSIS foreach loop.

@HarithaMaddi-MSFT please direct it to the right group.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-11T09:19:40.923+00:00

    Hi @Khatri, Ashish ,

    The Azure Blob Enumerator enables an SSIS package to enumerate blob files in the specified blob location. You can store the name of the enumerated blob file in a variable and use it in tasks inside the Foreach Loop Container.
    The Azure Blob Enumerator is a component of the SQL Server Integration Services (SSIS) Feature Pack for Azure for SQL Server 2016 (13.x). Download the Feature Pack here

    Please refer to Enumerator = Foreach Azure Blob Enumerator.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.