I think that XML does have legitimate uses, but large-scale data storage and retrieval is not one of them. I presume a lot of people spent a lot of time...

Brian, thanks for the response. This is very much at the proof of concept stage right now. To give you an idea of how I was thinking of setting things...

I am not arguing nor disapproving anyone and fully appreciate the time people took to reply.

My concern was if the proposed solution, with several SELECT statements from the same...

Not sure...

Welcome to the wonderfully non-intuitive world of XQuery! Here is some T-SQL which does the job. If you want to understand exactly how it works ................ ([Phil starts whistling and...

My German is not good enough to understand all of your screenshots, and as you have not provided any usable sample code, I cannot provide a coded solution. But I...

Why not run a quick test and find out for yourself?

Do a DB schema compare against what you have stored in source control to identify any 'drift'.

Not answering your question, but a quick note about your existing SQL, as it can be made considerably more concise, using the following structure:

SELECT *
FROM src
 ...

Hi, I have included FIRE_TRIGGERS in fast load mode and my package is failing with error "An error was raised during trigger execution. The batch has been aborted and...

Hi Phil,

Yeah its identical, I am simply executing the execute SQL task by right clicking on it in VS.

That works whereas running the package in its entirety causes the...

Are you 100% certain that exactly the same SQL is being executed in each case?

'Null' is a string. Do you really have strings containing the word 'Null'?

NULL is the absence of data.

As you don't want to remove all rows, your TRUNCATE comment is not...

But surely regardless of where and how I store it, the issue I've got is how to extract it (the version)

I'm sure I'll figure something out once I've been...

It's certainly an option, although whilst I try to make all my scripts "idiot proof" I can't vouch for how meticulous the DBAs are that I'll be handing the...