Stored Procedure as source in SSIS

Database

Stored Procedure as source in SSIS

I'd like to use a stored procedure as a data source in SSIS (to eventually export to a text file) but the SP doesn't return column information. Is there any way to use an SP as a data source in SSIS? Or do I have to just use the SP to insert to tables and then use the tables as the data source in SSIS?

Thanks for any help.