I currently have a Data Pump going to a text file using an SQL query as
the source however, this query changes dynamically and so the source
columns aren't known until it is executed. Is there any way of getting
the column information from the source so that I can change the
following properties in an ActiveX script?

conRecordsTextFile.ConnectionProperties("Column Names").Value = ...
conRecordsTextFile.ConnectionProperties("Column Lengths").Value = ...
conRecordsTextFile.ConnectionProperties("Number Of Column").Value =
....

At the moment they are blank and so it is erroring with the message...

"Incomplete file format information"

Thanks

Glenn.