I have a Master.DB that has initial tables setup that need to be expanded with the above inputs. That I want to copy to the
proper name as the setup of the Output File.
The Input files come with monthly names and the out database file needs to be monthly named however the table names
rename generic from month to month to make the 100+ SQL scripts not need to be updated going forward.
I would need to override the Input FileNames & Output FileName as I run thru the process each month. From what I have read
it would appear I need
and that the
would not allow Command Line Processing, correct? I am the only that
needs to run this so I am not trying to pass the processing along to someone else to do. Just automate going forward.
Keith Request received via Email
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Command line parameters are only accepted by the
. Here it would be possible to use also wildcards.
FHBatch.exe /ReadFileName *.csv Your-Import-Definition.fhd
But there are two other ways available to proceed some files automatically.
If you daily receive a file with the current date as part of the file name you may use
. This parameter can be dynamically set with the help of the
.NET Script Heater
or with a pre dummy processing step. I´ve made two short examples to demonstrate this. Please have a look to the attachment. In this case you never have to change the read file name before executing the Definition.
you can perform a directory monitoring. The
starts the Definition as soon as a new file is available in this folder. The
also take care about the file name and changes this automatically before executing the Definition, no further interaction is needed.