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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics