0

I need to load a .xlsx source to do some things. I've made an Excel Connection Manager and it works but I need to parameterize it to use a dynamic path. How can I do that? I've read a lot of guides but I couldn't get it to work. How do I define the path variable and how do I use it?

digital.aaron
  • 5,435
  • 2
  • 24
  • 43
marko
  • 487
  • 1
  • 6
  • 15
  • 1
    Possible duplicate of https://stackoverflow.com/questions/52962691/how-to-set-file-source-via-parameter-in-ssis – Ferdipux Feb 06 '20 at 15:37
  • 1
    Does this answer your question? [How to set file source via Parameter in SSIS?](https://stackoverflow.com/questions/52962691/how-to-set-file-source-via-parameter-in-ssis) – digital.aaron Feb 07 '20 at 00:13
  • yes, thanks @digital.aaron – marko Feb 07 '20 at 08:24

0 Answers0