Hi, I have an R code which I want to run in an SSIS procedure. So the R-code would output a count with an inputted script. The SSIS package is to spool data from source to destination, and the R code takes count of this spool. However, we have different spools everyday and I do not want to start changing the inputs(script) each time there is a new spool.
So the only option I can think of is to assign a variable name to the scripts on SSIS so I do not always hardcode the R script, but just change the scripts on SSIS for a new spool and assign it to tthe same variable earlier indicated on my R code.
please if this is the only option, how do I go about it?