Create a dynamic Folder Path in SSIS Flexible File Destination

user_12077980 0
Viewed 374

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 variable thisYear and thisMonth but how do I use those variables 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. enter image description here

My full data flow as below:

enter image description here

azure-data-lake-gen2 ssis
1 Answers

I managed to solve it by setting the 'Expressions' in the data flow task enter image description here

user_120779800
Related