question

KhatriAshish-1435 avatar image
0 Votes"
KhatriAshish-1435 asked KhatriAshish-1435 commented

Azure File share sub directory enumerator using SSIS foreachloop

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-factorysql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@khatriashish-1435 Thanks for using Microsoft Q&A !!
I am looking into this and get back to you on the same.

1 Vote 1 ·

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered KhatriAshish-1435 commented

Hi @KhatriAshish-1435 ,

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.


· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have all my files siting in azure file share that is why I am looking the solution for file share not for blob container. My for each loop container pick file at runtime from filshare.

0 Votes 0 ·

@khatriashish-1435 Following up to know if you are still trying for a solution of this issue ?

0 Votes 0 ·

@SaurabhSharma-msft no I used UNC path and it worked for me.

0 Votes 0 ·
Show more comments

Hi @KhatriAshish-1435 ,

If the answer is helpful, please click "Accept Answer" and upvote it.

Best Regards,
Mona

0 Votes 0 ·

this is is with all the adf only working on a one adf but rest all enumerates empty.

0 Votes 0 ·