I want to run an ETL transformation from command-line which processes an input CSV file (passed in as an argument); this CSV file can be dynamic and the header fields can be different for each input file. The problem is I need to automate the 'Get Fields' click action for each input file to resolve the respective header fields for each file before moving on to the other steps of the ETL process. On searching the net there are few pointers that suggest trying 'metadata injection' and after giving it a try this does not seem to work and I'm unable to find any documented solution for this problem.

If anyone has a solution or any suggestion to this problem it would be very helpful.

Best Regards,