Hey Mick,

Not sure what you mean exactly by 'implement the relationships within the XML structures'? If you mean something like ' i want to add a Country element named...

Apologies upfront Mick as I'm not directly answering your question :hehe: But, on reading that you need several sections to the document, possibly a simpler approach could be to create/import...

A quick google search should help on that (generally, people will have distributables, like an installer, to assist in getting it installed). 'Back in the day' I would use...

Would have to look it up, but would assume the assembly needs to be in the GAC on any machine you want to run this on.

I'm partial to them too, but like putting equations on Precedence Constraints, it's not something that gets done 'all the time' . I often create packages that are maintained by...

Jamie Thompson gives a pretty good example on his blog, here.

HTH,

You *should* be able to do a process update on the dimension alone, but not being there and seeing what you've got, I could be wrong and it may require...

True, my bad (teach me to answer without looking again at a package :hehe: ). Definitely by design. Would seem to get the result the OP wanted (assuming...

Because the precedence constraint is (most likely) success based on the split. This success has nothihng to do with rows passed, simply did the transform complete successfully, which is...

One approach is to add it before you get to the dimension. So, in the Data Source View, right click the table name and select the option to add...

Try adding the reference through the UI?

*One* way (and I am sure there are many others) to achieve this would be to:

- create a variable to store/hold row count

- add a Row Count transformation after the...

I tried using an expression on the destination file path, but SSIS was adding in a \ which I wasn't expecting,so I've had to go down the route of writing...

Have you tried Expressions? Seems like the scripting/variable approach would be a little overkill but I'm not fully up onthe requirement.

Proclarity has been gone for a while (basically since its acquisition by msft, though you could still get it for a little while post that event). The PerfPoint is...