Share via

Create a dynamic Folder Path in SSIS Azure Flexible File Destination

Muhammad Mukhtar 1 Reputation point
2021-08-04T01:11:36.193+00:00

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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.