PCWC66, thanks for pointing out that article. It is one of the best best primers on SqlBulkCopy that I have seen. It is definitely a great technique for the right circumstances, but there are times when it is desirable to keep things T-SQL pure or nearly so.
---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/