Hi Experts,
I have to get row count from flat file source and count should be displayed as print function in the trace log.
Thanks,
Venki
ursfriend77 (BOB member since 2011-03-02)
Hi Experts,
I have to get row count from flat file source and count should be displayed as print function in the trace log.
Thanks,
Venki
ursfriend77 (BOB member since 2011-03-02)
do an OB/GB on DI_FILENAME and load that to a table, then use a sql statement to select & print it to the tracelog.
or if its fixed width you can calculate it by dividing the file size by the record length.
if its a delimited file you of course have to cross your fingers that the buggy ds reader doesnt stop reading when it encounters an embedded field framing character. “this"is”,“treated”,“like”,“an”,“end”,“of”,“file”
jlynn73 (BOB member since 2009-10-27)