Hello Again
>>>Is it possible to create a “batch” file to run different .ats imports in a row automatically?
You can run ats file from command line advancedetl.exe transformation_file.ats
Eventually you would want to add some other stuff to it eg ftp downloads, file operations, email notifications etc. from my point of view enterprise version is the best for automation.
>>>How can I define a static value for a field in the target database?
Use literal function
>>>Is it possible to define a static value for a field depending on the name of the import source file name? We will have to import files from 17 different branches into 1 database and would like to automate this. Now I’m trying to find a solution how I could simply add the branch ID to a field in my target table. I was thinking to name the source files for each branch differently and then have a logic in the import script to set different values. Is this possible? Or do you have other solutions to get the same result?
Reader parameter function can return source file name.
If you create files like order.branch_id.csv you can use splitter to get branch_id.
Another way is to include branch_id into the file data.
Mike
