Excute Process Task for parameters
Hi,
currently I have a cmd file named h.cmd and there is some database setting inside the flie see below attachment. I would like use SSIS Execute Process Task to call this cmd file and pass in the value for the database setting INSTALL_HOST,Install_DB etc rather
than each time open the cmd to modify the connection info. In a work, I will make connection information to store in the package configuration and pass the value to cmd. How can I do it? I saw arguments and StandardInputVariables but I do not know
which one I need to use. And how to use? Thanks
@REM Set the appropriate Database parameters.
set INSTALL_HOST=**
set INSTALL_DB=**
set INSTALL_UID=***
set INSTALL_PWD=***
set QUERYFILE=HelenCmd.sql
call :XECSQL
@REM====================================================================
@REM Invoke the query stored in QUERYFILE
@REM====================================================================
:XECSQL
@sqlcmd -U %INSTALL_UID% -P %INSTALL_PWD% -S %INSTALL_HOST% -d %INSTALL_DB% -i %QUERYFILE% -o %QUERYFILE%.log
goto :EOF
Helen
November 9th, 2010 8:27pm