Not sure what the purpose is but why not just use a sql task in a for each file loop container to identify for differencies, or a sql task after...

Just been looking at http://www.agiledata.org, good find, thanks for pointing it out.

Been looking at DSDM Atern a bit more and it's more of a project management technique than project management technique, but many of the principals are common, so I guess...

If there is a 'drop down on the front end' where is the data for that coming from? why not use the same source, you'll save on maintenance and build...

Use the pivot task.

There are quite a few ways of getting data into SQL, choosing the best option will depend on the files and their format (e.g. If there are some standard between...

Your taking a path I've never had to walk. I've never tried unioning two cubes like this before, I've always had virtual cubes and partitions. You could try googling it.

If you have a complex view I would strongly suggest you look at turning it into a physical table. This will mean that a lot of work is done by...

I personally dont think it can work one tiny little bit. I'm just looking to see if anyone has made it work, and if so, how they did it.

Two questions. Have you tried running this out of design time? I've experienced hanging in design mode have a package run successful out of it. The second question is -...

This message is refering to a 'value' not the fact that a key is missing. You DSV is showing the 'key' is there but can it handle the value of...

Your correct. Running in design time will result in using the connections from the connection manager rather than you file.

Running any package not in design will ensure the package uses...

Well, thats one way to do it. Maintenance will be a bit of a bugger though, and I'm not to sure what would happen if your hierarchies got out of...

I take LutzM's point, but you've helped me tremendously so thanks. Never having to touch XML previously this would have taken an age to figure it out myself.

Thanks, for the link.

Sample Data from a field called XMLRequest in table ClientRequest -

<apicr xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" phase="6a" entrypoint="Search06a" xmlns="urn:OurCompName.plc.uk/api5"><payload><userhostaddress xmlns="urn:OurCompName.plc.uk/private">127.0.0.1</userhostaddress></payload><thrierequest><applicant><address><abodeno/><buildingno>1</buildingno><buildingname/><street1>made up street</street1><street2>made up place</street2><sublocality/><locality/><posttown/><premiseno>1</premiseno><premisename/><postcode>zz56 4zz</postcode><duration/></address><name><title>MR</title><forename>BEN</forename><othernames/><surname>FRANKLIN</surname><suffix/></name><dob>1822-01-03</dob><tpoptout>1</tpoptout></applicant><score>1</score><purpose>AA</purpose><transient>0</transient></theirrequest></apicr>

Basic query that might be run...