if not exists(select top 1 id from dbo.ProcessFile)
begin
	--drop out if there are no files to process
	return
end


--set up the conversation
DECLARE @handle uniqueidentifier
BEGIN DIALOG CONVERSATION @handle
FROM SERVICE FileProcessService
TO SERVICE 'FileProcessService_receive'
ON CONTRACT FileContract;

--start sending messages
declare @id bigint
declare @folder varchar(255)
declare @filename varchar(255)
declare @message xml

--loop through the records that are unprocessed
declare curs1 cursor FAST_FORWARD for 
	select ID,folder,filename from dbo.ProcessFile where status=0
open curs1
fetch next from curs1 into @id,@folder,@filename
while @@FETCH_STATUS=0
begin
	--set the message
	set @message='<message><file>'
	--+@folder+'\'
	--+@filename
	+'X</file></message>'
	print convert(varchar(max),@message)
	--Sends a message
	;SEND ON CONVERSATION @handle
	MESSAGE TYPE ImportFile
	(@message)
	--mark it as sent to queue
	update dbo.ProcessFile set status=1 where ID=@id
	fetch next from curs1 into @id,@folder,@filename
end
close curs1
deallocate curs1
--And ends the conversation
END CONVERSATION @handle WITH CLEANUP;

CREATE TABLE [dbo].[ProcessFile](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[folder] [varchar](255) NOT NULL,
	[filename] [varchar](255) NOT NULL,
	[status] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into Processfile (folder,filename,status) select 'c:\files','text.csv',0)