The real joins actually have four other parts. It seemed unrealistic to post the entire schema and would have taken an age to anonymise.

The originally suggested solution appears to work...

Sorry, just typed in a simulation of what I actually have. Group is there 🙂

Nice thinking. I was trying to avoid writing a ton of unions, I'll try your suggestion.

Okay, ignore me, I've got to the bottom of it.

The Script Task contained a String.Format, which used a variable value as the format. This needed to be reset back...

This was already the case.

It took about three minutes 🙂

Thanks Gail, this worked....

It's now actually doing something using this command! 🙂

I'm not sure how long this will take though.

Yes, the file is there at that path.

Ha, yes. I just treble-checked and added a USE to be sure. I wish it was that simple 🙂

That basically gives the same error as I get in the UI :/

"Could not locate file 'NewArchiveData_log' for database 'ArchiveData' in sys.database_files. The file either does not exist, or was...

Results:

namephysical_namefile_guidfile_idtype

NewArchiveDataF:\Data\ArchiveData.mdfE4906318-99EC-4E9A-9BE2-EFEE790AACD710

NewArchiveData_logF:\Data\ArchiveData_log.ldfF0E37EDF-F3BB-468E-B00C-7DA012C5372C21

I was sick of creating SSIS packages, especially for something that should be quite simple, and wanted to try

the sp_send_dbmail proc that John pointed out.

The proc worked...

Hi John,

I just didn't know about that system proc. Thanks!

I'm going to completely turn this around now and say, I don't want to capture the result and email a file, I want to show the result in the body...

Eugene Elutin (3/12/2012)

---

Looking into your UDF, it would definitely benefit from implementing it as CLR function.

Also, you can try to split your query in two parts.

First filtering out everything...

Ed B (3/14/2012)

---

CraigIW (3/12/2012)

---

Did you...