why use bcp at all? Whats wrong with a SQLAgent job that outputs to a text file?

That sounds easier and quicker than a C# routine and SMO 🙂