SP's Output Into Text File

I am using SQL Server 2000.



Wanted to get the below result of below SP in text file using DTS. SP's out put is mix of text lines (as in print statement) and result of a table (FinInterface.dbo.UsersThatDontExist ). I am having difficulty to have the results of sp in text file. Any help there!!!!



CREATE PROCEDURE [dbo].[F1USERLIST] AS

print '========================================='
print 'Finance One Daily User Records Report '

declare @recordcount as int
declare @nodename sysname
Exec master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SYSTEMCurrentControlSetControlComputerNameComputerName',
@value_name='ComputerName', @value=@NodeName OUTPUT

print getdate()
print '========================================='
print 'This email was generated automatically by'
Print 'Data Transformation Service(DTS Package): Finance One user List 2'
Print 'In Database : ' + db_name()
Print 'On Server : ' + @NodeName
Print ' '
print '-----------------------------------------------------------------'
Select @RecordCount=(select count(*) from FinInterface.dbo.UsersThatDontExist)
If @RecordCount>0
begin
SELECT user_id AS USERNAME,
fst_name AS FIRST_NAME,
lst_name AS LAST_NAME
FROM FinInterface.dbo.UsersThatDontExist
Print 'There were ' + ltrim(str(@RecordCount)) + ' users in Finance One with incorrect information'
end
else
Print 'All users in Finance One have valid information'
print 'ACTION REQUIRED: Please update the user information in Finance One'
print '======================================='
Print 'End of Report'

GO