More Info:
1. TDML stage is not working even in server jobs imported from another environment. I receive the same error on server jobs.
2. Setting Combinability to 'Don't Combine' let me see that the parsing of the sequential file was working correctly and that it was the TDML stage not working. The error messages under this setup become:
Teradata_Multiload_8,0: Failure during execution of operator logic.
Teradata_Multiload_8,0: Input 0 consumed 0 records.
Teradata_Multiload_8,0: Fatal Error: Fatal: Unable to start MultiLoad process mload: system returns errno=2: The system cannot find the file specified.
SrcTestUpdatesSeq,0: Internal Error: (shbuf): iomgr\iomgr.C: 1729
node_node2: Player 1 terminated unexpectedly.
node_node1: Player 1 terminated unexpectedly.
3. Using the server job, I ran with tracing on and received the following messages:
MultiLoadTest..Copy_of_Teradata_Multiload_0: Starting process mload < H:\DEV_DW00QL\Control.ctl > H:\DEV_DW00QL\Report.rpt
MultiLoadTest..Copy_of_Teradata_Multiload_0: Unable to start MultiLoad process mload: system returns errno=2: The system cannot find the file specified.
4. The control file in both Parallel and Server jobs is being written, and the report file is created (empty). Also, when I log into DS environment and run 'mload', it does not find it. I'm guess that this should be installed with the DBMS package and not the Teradata utilities package that comes with DataStage?