March 9, 2020 at 8:28 pm
I'm trying to pass a date to an azure blob storage source within a ForEach Loop and it doesn't look like it takes a dynamic filename. The ForEach Loop needs to find files after a date specified by a variable and then import it into a SQL Table.
For the life of me I can't figure out how to do this. I've hooked my ForEach loop up to the container and I set my vFilename variable but I can't do anything with it since I can't take that variable value and use it in my Azure Source Blob.
has anyone done this?
Thank you
March 9, 2020 at 9:49 pm
I'm trying to pass a date to an azure blob storage source within a ForEach Loop and it doesn't look like it takes a dynamic filename. The ForEach Loop needs to find files after a date specified by a variable and then import it into a SQL Table.
For the life of me I can't figure out how to do this. I've hooked my ForEach loop up to the container and I set my vFilename variable but I can't do anything with it since I can't take that variable value and use it in my Azure Source Blob.
has anyone done this?
Thank you
I've never done this, but I was interested so had a quick play around. And at this point, I agree with you. I cannot see any way of making the Azure Blob Source dynamic.
I then had a look at the 'Flexible File Source', which appears about as flexible as a snooker table, and does not appear open to parameterisation.
I will continue to follow this thread with interest.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply