Four Stars

Can't write to csv or txt file with tFileOutputDelimited

Hi,

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?

immagine.png

2 REPLIES
Six Stars

Re: Can't write to csv or txt file with tFileOutputDelimited

Hi Mary,

 

Place a tlogrow component between Oracle and fileoutput component, so that you can print what has been retrieved on to the console.'

 

thanks

Ashok 

Moderator

Re: Can't write to csv or txt file with tFileOutputDelimited

Hello,

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.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.