Importing files from azure blob source into SQL Tables - by date range

• cathryn.crane

  SSC Veteran

  Points: 203

  More actions

  March 9, 2020 at 8:28 pm

  #3732614

  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

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  March 9, 2020 at 9:49 pm

  #3732625

  cathryn.crane wrote:

  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.

  ---