Create a dynamic Folder Path in SSIS Flexible File Destination

Question

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.

My full data flow as below:

In my datalake, I will have testdump/@[User::thisYear]/@[User::thisMonth] folder path instead of testdump/2021/08 — rain123, Aug 04 '21 at 01:03
what are the values for @[User::thisYear] and @[User::thisMonth] ? — Amira Bedhiafi, Aug 04 '21 at 09:17

score 3 · Accepted Answer · answered Aug 08 '21 at 01:47

3

I managed to solve it by setting the 'Expressions' in the data flow task

answered Aug 08 '21 at 01:47

rain123

243
4
13

Create a dynamic Folder Path in SSIS Flexible File Destination

1 Answers1