When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
in my parameter file. Within Pwershell, it will set the values of $ROOT and $PACKAGE_CMD_LINE to the appropriate values. Then, within the code, I want Powershell to replace the '%ROOT%' "tags" within the $PACKAGE_CMD_LINE variable with the value of the $ROOT variable, which has already been processed. Can someone assist me as to how this might be accomplished.
ROOT,C:\SomeFolder\SomeFolder2\SomeFolder3\HomeFolder PACKAGE_CMD_LINE,/FILE "%ROOT%\MyPackage.dtsx" /CONFIGFILE "%ROOT%\MyConfig1.dtsConfig" /CONFIGFILE "%ROOT%\MyConfig2.dtsConfig" /WARNASERROR /CHECKPOINTING OFF /REPORTING EWD /CONSOLELOG NCOT
But $PACKAGE_CMD_LINE would have had occurances of '%ROOT%' replaced with the value of $ROOT.
& DtExec.exe $PACKAGE_CMD_LINE