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?
-
1Possible duplicate of stackoverflow.com/questions/52962691/…Ferdipux– Ferdipux2020-02-06 15:37:05 +00:00Commented Feb 6, 2020 at 15:37
-
1Does this answer your question? How to set file source via Parameter in SSIS?digital.aaron– digital.aaron2020-02-07 00:13:24 +00:00Commented Feb 7, 2020 at 0:13
-
yes, thanks @digital.aaronmarko– marko2020-02-07 08:24:07 +00:00Commented Feb 7, 2020 at 8:24
Add a comment
|