I can't believe this is the slickest way to achieve what you're after, but this works :w00t:
[font="Arial Black"]CREATE PROCEDURE EXPORT_DATA
@FileName varchar(255)
as
begin
declare @bcpCommand varchar(255), @Result int
set @bcpCommand = 'bcp "Select 1...