We need to produce data files for transfer to another system. i.e. Run a stored proc and produce a pipe delimited text file.

What we're doing at the moment is running everything through a .Net app that runs the stored proc and romps through the resulting table to build the text file. This works, but we'd like to do some type of SSRS/SSIS package so these runs can be scheduled and automated. Is this possible, and if so - would someone be so kind as to point me towards some documentation/examples/etc.?

How do y'all do this?

Thanks