Hello Phil

In this instance SQL 2008 R2 BIDS

Thanks

Thanks for the feedback
Think I get this now

Think some of the examples where a record is deleted then an audit of the deletion are better
e.g. 

interesting question

Thanks, a package with a loop seems like a sensible option
So literally read everything in and use SQL to handle the database name extraction

Not that it necessarily helps you here but I would never start data with leading zeros as, the chances are, it will end up in Excel at some point.
Appreciate...

Just had an initial glance and that looks like an interesting approach
So, I could create a schema and compare the XML to the schema using TRY, CATCH
TRY, CATCH...

Problem seems to be, forcing success reults in success
All I (think?) really need to do is, in some way flag it as having failed but continue successfully such that...

Ah right, yes that makes sense Phil

About to leave for the day so i'll give that a go in the morning

Much appreciated

Damian.

Hello Matt

I have a DataFlow that's using an XML Source
Here I specifiy the XML and XSD

It does and I think it's a mix of OnError and (something I've just stumbled across) ForceExecutionResult

ForceExecutionResult = Success looks to ensure that the task doesn't return a...

I have looked at the MS reference and it does look like it's been used correctly
Doesn't look like this works in SSIS
Did wonder if there was a setting...

Thanks

So does use="required" actually do anything
Presumably, I just use minOccurs="1" maxOccurs="1" rather than use="required"

Thanks for the reply

The variable has a value in it. By default it points to my development server - although I expect this to change at run time

Hi Robert

How far did you get regarding certification options
I'm in a potentially similar position

Thanks