I'm trying to read rows from a database table and write them to a csv or txt file. When I execute the job, it tells me that it has retrieved a number of rows (so I suppose it all went well), but then my .csv file is empty.
How can I check if those rows were really retrieved, or where is the problem?
Place a tlogrow component between Oracle and fileoutput component, so that you can print what has been retrieved on to the console.'
Please try to click 'Sync columns' buttion on the basic settings of tfileoutputdelimited component to see if it works. This will take automatically the columns of the previous component.