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]
