Tx Ivan for the work around ... It is however a bit frustrating to have a neat tool and then to have to mess about to do smthg trivial. Especially that one can remove the ResultSet columns header with a simple switch ...
\T, --- Ivan Ivanov <[EMAIL PROTECTED]> wrote: > Hello, > > --- [EMAIL PROTECTED] wrote: > > My only problem is that the ouptu is as follows : > > <snip> > > 9002 > > 9003 > > 9005 > > 9006 > > 9000 > > 9001 > > > > 0 rows affected > > </snip> > > > > How can I remove the last line... indicating the nbr > > of lines impacted ... ? > > It does not come to my mind how to configure sql task > to not ouptput its last line; anyway you can copy the > output file with tail filter skiping the last line: > > <project> > <copy file="outputfile" tofile="outputfile1"> > <filterchain> > <tailfilter skip="1"/> > </filterchain> > </copy> > </project> > > Another way is to replace the string "O rows affected" > with the empty string: > <project> > <replaceregexp file="output"> > <regexp pattern="0 rows affected"/> > <substitution expression=""/> > </replaceregexp> > </project> > > HTH Ivan > > > > > Tia, > > > > \T, > > > > __________________________________ > Do you Yahoo!? > Yahoo! Sports - Sign up for Fantasy Baseball. > http://baseball.fantasysports.yahoo.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Any fool can write code that a computer can understand. Good programmers write code that humans can understand. Martin Fowler T. : +32 (0)2 742 05 94 M. : +32 (0)497 44 68 12 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
