Just a minor point, but for a general solution my inclination would be to replace "SN" with "SN=" in the charindex. It's not beyond the bounds of possibility that...

Good point Phil. Probably neater to do it that way (and no need for any scripts).

Yes, but it will recalculate that connectionstring every time it uses it (i.e. every time round the loop).

Create a new variable User::FullOutputFileName (or whatever), and assign its value as:

RIGHT("0" +...

(and obviously make sure you've got Overwrite=False in the Flat File Destination properties - I think that the default is True).

The only way I can see you getting multiple files from that connectionstring is if it was taking more than a second to process each file. Each time you...

Are you getting multiple files with different times in the name, or are you getting a single file which is being overwritten each time round the loop?

What is the connectionstring set to in the connection manager for the output file? I can't see how you can get multiple files unless you're renaming dynamically during the...

I may be completely misunderstanding, but surely if you miss out the WHERE clause (and maybe replace it with "ORDER BY COUNT (A.N#OfAims)"), then this will give you all the...

It's a bit of a bodge and wouldn't work if your times stretched to hh:mm:ss rather than just mm:ss, but this does the trick.

order by convert(decimal(5,2),REPLACE(colname,':','.'))

Hugo Kornelis (4/2/2013)

---

Good question, but the explanation falls a bit short. I was very disappointed when I first saw this behaviour. A semicolon is a statement terminator and should be...

Raghavendra Mudugal (1/31/2013)

---

Good One, thank you for posting.

(having known on the computed column but never used computed inside another computed column, so was not 100% sure if the answer was...

Given that the selections only add up to 188%, I don't think everyone's taken...

It's not the order that I was questioning, but the combination of string and identity. If it wasn't for the "feature" being highlighted, "Shovel" would be in there with...

It may just be an astounding coincidence, but the layout of Steve's example and the one in the...

I'm with Hugo on this one that it's a documentation bug on that page. It even states on the very first line of the BOL link provided (their emphasis)...