override the input command and before you start enumerating the select 
query execute the purge sql.

class myinputcommand : InputCommand
{
    override IEnumerable<Row> Execute(IEnumerable<Row> rows)
   {
             execute purge statement
             return base.Execute(rows);
   }
}

On Tuesday, March 19, 2013 7:31:02 AM UTC-4, Wayne Douglas wrote:
>
> hi
>
> I want to clear down all rows in a table before the etl starts - I have a 
> stored proc that truncates the data.
>
> What is the best way to do that?
>
> -- 
> Cheers,
>
> w:// 
>

-- 
You received this message because you are subscribed to the Google Groups 
"Rhino Tools Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to