Hi Philippe and Vikki,
PREFACE: Philipe, have you already read my reply where I advised to Vikki to open a new own thread for her(him?) issue instead of start it under Jennifer's (jgrams) original thread? As I suppose, you use the List so you do not see the thread on the Forum which became a bit confused just read the post as e-mail and reply it helpfully.
OK, I will also reply here again.
Philippe is right that use "Format is Fetched" event but I have some addition:
1.) If the TC see the flat file as OneWorld table instead of as a Foreign table then the "Row is Fetched" event the appropriate
2.) You can map Output Columns as well on the mapping screen as well in the event making assignments to the OC type fields.
3.) Do not forget to mark the "Issue a Write for this Event?" check-box. ///Personal NOTE: I have met with a case on the Forum where this was the problem only but we walked around the entire OneWorld making a lot private and personal mail exchange before we found this pretty little bug. I hope he will read this too and will again laugh a good on it
Excuse me, I wasn't able to resist to write it. ///
4.) Starting from B733, 2 and 3 is not necessary. You can issue Insert Table IO in the event and you can map the columns there inside the Insert statement.
At last a possible problem can occur when input values are not uniques for the unique indicies of the output table and some or all of insertations will fail. Check the jde.log that does it occured or not.
Good luck & success for exploring Table Conversion,
Zoltán
B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)