Combining multiple scripts into one file
I have an SSIS package that has a variable passed to it which is a customer specific run id.
One of the steps in the SSIS package is an execute process task that calls a specific winSCP script file on the file system. There is a separate process task for each customer (only one customer is run on each execution of the package). This uses the standard syntax of: /console /script="C:\parent_folder\customer_folder\customer_winscpScript.txt" as described on https://winscp.net/eng/docs/guide_ssis.
I would like to be able to combine all the individual customer scripts into one file and pass it the variable used by the SSIS package so that the code for that customer gets executed.
Is this possible using the scripting syntax or does it require something more complex?
I apologize if I did not search enough, but I was not able to find anything obvious that addressed this question.
Any assistance would be appreciated.
One of the steps in the SSIS package is an execute process task that calls a specific winSCP script file on the file system. There is a separate process task for each customer (only one customer is run on each execution of the package). This uses the standard syntax of: /console /script="C:\parent_folder\customer_folder\customer_winscpScript.txt" as described on https://winscp.net/eng/docs/guide_ssis.
I would like to be able to combine all the individual customer scripts into one file and pass it the variable used by the SSIS package so that the code for that customer gets executed.
Is this possible using the scripting syntax or does it require something more complex?
I apologize if I did not search enough, but I was not able to find anything obvious that addressed this question.
Any assistance would be appreciated.
