Batch Script for generate Parameter file

6- Batch Script for generate Parameter file for any job flow.   

@ Echo Off

SET INFA_SHARED = SERVER NAME (DECLARED IN ENVIRONMENT SCRIPT)

echo [Global]> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo:>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

:: Get Date for the FROM TABLE

sqlcmd -Q "set nocount on; SELECT CONVERT(VARCHAR(10),Data_As_Of_Date,101) FROM (SELECT MAX(Data_As_Of_Date) as Data_As_Of_Date From TableName Where Process_Name='DailyFlow' AND Frequency_Code='D')X " -h -1 -k -r -o %INFA_SHARED%\Parameters\Monetary_Daily.txt

 

Set /p ABCD_Date=< %INFA_SHARED%\Parameters\infa_daily.txt

Set /p CheckDate=< %INFA_SHARED%\Parameters\infa_daily.txt

Set /p CheckNul=< %INFA_SHARED%\Parameters\infa_daily.txt

:: Check for DB error

Set CheckDate = %CheckDate:~3%

if %CheckDate% == Msg (exit 1)

del /f %INFA_SHARED%\Parameters\infa_daily.txt

:: Check for NULL Return on Query

if %CheckNul% == NULL (exit 1)

del /f %INFA_SHARED%\Parameters\infa_daily.txt

:: Write all the required parameter in the file

echo $$dDate=%ABCD_Date%>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo $$MdDate=EOMONTH(DATEADD(M,-1,GETDATE()))>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo:>>%INFA_SHARED%\Parameters\wf_infa_daily.prm

echo $Param_SchemaName=SchemaName>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo $DBConnectionSource=wf_Connection_Name>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo $DBConnectionTarget=wf_Connection_Name>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

>> %INFA_SHARED%\Parameters\wf_infa_daily.prm echo $PMSessionErrorThreshold=1

echo:>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo [s_SessionName]>> %INFA_SHARED%\Parameters\wf_infa_daily.prm

echo $Param_Tgt_Table=Load_FTD_Area_Balance>> %INFA_SHARED%\Parameters\wf_infa_daily.prm