This content has been marked as final. Show 2 replies
The entire path of the file produced by the standard Export is strFile from:
Sub AftExportToDat(strLoc, strCat, strPer, strTCat, strTPer, strFile)
AftExportToDat runs several times during Export, so you may want to include something like the following at the beginning of AftExportToDat to avoid unexpected results:
Select Case LCase(Right(strFile,6))
Case "-a.dat", "-b.dat", "-c.dat" Exit Sub
I'm not sure how to determine the name of the file generated by the Pull Adapter. Can you add the Pull Adapter's type library into the Object Explorer in Workbench?
The name of the file produced by the pull adapter is in the strFile parameter of the AftExportToDat event script.
Thanks for the tip that the script may be executed more than once. I would have been scrarching my head trying to figure out what was happening.