You can export data directly from a stored procedure by using xp_cmdshell and running a bcp command on the operating system.

I appreciated you article on SSIS. It is timeconsuming to use SSIS in a lot of situations like yours.

You might be able to eliminate SSIS completely. You can use xp_cmdshell...

No tool or method is perfect.

There are other tools and methods instead of using SSIS or c#:

Take a look at BCP - been around for a long time, included with...