Hi,

My scenario is, I need to create a Target XML file where the file name is of the format:

<File_ID>_<mmddyyyy>_<hhmmss>.xml

Where Fille_ID is a field from the Source Oracle DB.

Can anyone help me with this.

Thanks in advance.

In the AfterFirstRecord event, perform a ChangeTarget action something like:

"+File=" & Fields("File_ID") & "_" & format(now(),"mmddyyyy_hhnnss") & ".xml"

It Works!!!!

Thanks a lot.