Reading variables used in select statements

[Flybridge]

I am incrementally extracting data. I use a variable to store the highest number in an index column and pass it to the Script task.
My extraction failed after 900 rows. I am assuming the data did not come into the data warehouse in numerical sequence.
How can I check to see what was the variable used in that last extraction so I can tidy up the data warehouse table before fixing and re-running the extraction?

Thanks.

'The world isn't round - it's bent!' Spike Milligan

 

[AlexCuse]

How are you doing the extraction?

If the variable you mention is not local to your script, it seems you could do any number of things to notify the user using an 'on failure' workflow, whether you throw the value in a table/file or send a notification message of some sort.

I apologize if I am missing something or you've already tried this.

Hope this helps,

Alex

[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

 

[Flybridge]

The issue was, having run an extraction that failed, how could I check the value of the variable passed to that extraction so that it only extracted the transactions not previously extracted (i.e. the highest transaction number in the data warehouse before the last extraction ran).
However, it is now acedemic. It seems if an extraction fails, even though it says it has extracted x thousand rows, it must roll them back as the data warehouse table didn't change.
So at the moment I'm not bothered about this, except only for acedemic reasons in case I need it in future.
Or perhaps someone else will need it at some point and learns from this post (if it gets answered).

'The world isn't round - it's bent!' Spike Milligan