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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy