Hi I plan to use the Bulk Exec task for MySql to load a data file into my staging tables for preprocessing. The stage table has a column which is company_connector_id that identifies the source of the data(this is an internal identifier). This column is obviously not available in the client data file coming in. If i was to load this data file through the MySql command i would use the command
load data local infile 'filepath/filename' into table stg fields terminated by '|' lines terminated by '\r\n' (column1, column2, column3....) set company_connector_id = 1234
The value of the company connector id would get set. How do i do this when i am using the tMySqlBulkExec task? I can pass it through a context but how can i set it through the task?
