Problem: [The code I am running is not the part of actual ETL] so for multiple DB environments I need to run single job [for Mock Conversions rejected data] and for each environment I have to manually update the parameters in the param file before running the job. my job takes all the parameters for running the job like "DB Host[Server]", "DB Schema", "DB_User" etc
Question: is there a way that anybody can run the job by simply passing the parameter values from excel file [people heat to do changes in param file and running from cmd causing so many failures e.g path is not correctly define, missing a parameter etc]
What I am trying to do is below:
have a Nice little Excel spreadsheet with all the parameters and their values for example.
Parameter | Value
DB_Schema | Application
DB_User | Scott
DB_Passwd | Tiger
... | ...
and a 'Button' to "Execute" the job.
Now on pressing the Execute button I want to pass the Values from the above list to my .bat file to run.
Hope I clear my question.
Thanks in Advance.
3 Replies - 2875 Views - Last Post: 17 January 2012 - 10:19 PM
Replies To: Passing Parameters from Excel to run a batch [.bat] file
Re: Passing Parameters from Excel to run a batch [.bat] file
Posted 17 January 2012 - 09:31 PM
Page 1 of 1