question

MuhammadMukhtar-4844 avatar image
0 Votes"
MuhammadMukhtar-4844 asked ZoeHui-MSFT edited

Create a dynamic Folder Path in SSIS Azure Flexible File Destination

I am trying to dump data into Azure Datalake Gen2 using SSIS. I found about Flexible File Destination Editor but I am stuck at setting the Folder Path dynamically. I have set the variables thisYear and thisMonth but how do I use them in my Folder Path?

I tried as below but it wouldnt give me the expected value of testdump/2021/08. Am I missing something? Please help.
120342-image.png


My full data flow as below. The output in my Datalake is testdump/@[User::thisYear]/@[User::thisMonth] instead of testdump/2021/08.
120249-image.png


sql-server-integration-services
image.png (66.2 KiB)
image.png (12.5 KiB)
· 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.

Hi @MuhammadMukhtar-4844, For the time being, I don't have the azure environment and I'm trying to build the environment.
I will inform you in time if there is an update, and let us know if you have any updates.

0 Votes 0 ·

0 Answers