Neat use of update. This can also be done using the FOR XML construct:

select SUBSTRING((SELECT (',' + id) FROM teste ORDER BY id FOR XML PATH('') ), 2, 1000)

Let me clarify that . What I mean is I don't use SSIS integrated logging because it is unwieldy and unflexible - I use custom logging.

I agree, this is an excellent article - I could have done with it before I took MCTS/MCITP in the last couple of months (although I did pass).

I think that...