My scenario is as follows : 

I have a  receive port which contains two receive location:first one used  a scheduler  adapter and 2nd one is used a file adapter.

When scheduler starts then the file processed.

But when we have more then one file in file receive location then only the first one file is processd. Why it is happening ?

To resolve this issue,I thought that I will count the number of files from receive location and then make a loop and processed

those file as seen in the following   screenshot:

but how will I get that how many files are there in receive location ?

Hi,

You should implement a Sequential Convoy pattern in your orchestration to receive every file that is present in the receive location in the same orchestration.

Please, take a look at the following links:

https://msdn.microsoft.com/en-us/library/aa561843.aspx

https://msdn.microsoft.com/en-us/library/aa547554.aspx?f=255&MSPPError=-2147217396

And a sample:http://girishbiz.blogspot.com.es/2014/02/biztalk-design-patterns-sequential.html

Regards.

Thanks for the reply ohwari.

I tried with the following orchestration design:

I break the loop with the following condition : 

loopCount<=2

But it is static.I want to break the loop on how many input file I received from file receive location ?

If there is three file then the loop will be run three time.How can I achieved

Why do have both the Scheduled Task Adapter and File Adapter on the Receive Port?  Meaning, why can't you use use just the File Adapter?

If you want to pickup files at a certain time only, then use the Service Window on the Schedule tab of the Receive Location.

The reason it's picking up only one file is the Scheduled Task Adapter's file provide is firing only once, and picking up only one file.  That's just how it's coded.

Hi,

I think the easiest way is to use a Listen with a Receive and a Delay shape if you don't know how many files are in the receive folder.

Configure the delay with a TimeSpan of 5 seconds for example. If no file is received in this interval (no more files available in the receive location), the delay shape will be fired. In the delay branch, you should exit the loop because there are no more files in the receive folder.

Regards.

You can only use file adapter to poll data from the file location and schedule the file adapter schedule window to run at specified interval of time .

Is there any problem you are facing while implementing your solution with file adapter only ?

Thanks

Abhishek

Hi All,

Actually this orchestration will run only once in a month on 1st day 6.00 am.So we have to use scheduler adapter.

Ok, this can be very simple.

If you have to process all waiting files at 0600 on the first of the month, then create a Windows Scheduled Task that moves all waiting files from the drop off location to another folder where the File Adapter Receive Location is watching.

Leave the Receive Location Enabled all the time.

Important question: Do the files have to be processed in some particular order or one by one?  We can't any more advice until we know this.

Ok, this can be very simple.

If you have to process all waiting files at 0600 on the first of the month, then create a Windows Scheduled Task that moves all waiting files from the drop off location to another folder where the File Adapter Receive Location is watching.

Leave the Receive Location Enabled all the time.

Important question: Do the files have to be processed in some particular order or one by one?  We can't any more advice until we know this.

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator 1 hour 42 minutes ago

Ok, this can be very simple.

If you have to process all waiting files at 0600 on the first of the month, then create a Windows Scheduled Task that moves all waiting files from the drop off location to another folder where the File Adapter Receive Location is watching.

Leave the Receive Location Enabled all the time.

Important question: Do the files have to be processed in some particular order or one by one?  We can't any more advice until we know this.

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator Monday, September 07, 2015 5:21 AM

Ok, this can be very simple.

If you have to process all waiting files at 0600 on the first of the month, then create a Windows Scheduled Task that moves all waiting files from the drop off location to another folder where the File Adapter Receive Location is watching.

Leave the Receive Location Enabled all the time.

Important question: Do the files have to be processed in some particular order or one by one?  We can't any more advice until we know this.

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator Monday, September 07, 2015 5:21 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator 18 hours 35 minutes ago

Ok, this can be very simple.

If you have to process all waiting files at 0600 on the first of the month, then create a Windows Scheduled Task that moves all waiting files from the drop off location to another folder where the File Adapter Receive Location is watching.

Leave the Receive Location Enabled all the time.

Important question: Do the files have to be processed in some particular order or one by one?  We can't any more advice until we know this.

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator Monday, September 07, 2015 5:21 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, September 08, 2015 12:26 PM

If Order of files processing is not required then I would say boatseller approach  suits your requirement. 

Similar scenarios has been asked in forums multiple times and the response is to use a file I/O component to do the task

Thanks

Abhishek   

Hi Prakash,

Is there secondary processing of the files or is it literally pick up data in files, and move that data to another resource such as SQL Server?

If so, then SQL Server Integration Services could well be a better fit for this and you can schedule when the package runs easily.

If you are simply moving files around, BizTalk is a very expensive file manager and something like a scheduled task would be a better solution.

If there is additional processing, then I'd definitely go with boatsellers solution of just leaving the receive location enabled and having a copy process.

Cheers,

Martin

Hi Prakash,

Is there secondary processing of the files or is it literally pick up data in files, and move that data to another resource such as SQL Server?

If so, then SQL Server Integration Services could well be a better fit for this and you can schedule when the package runs easily.

If you are simply moving files around, BizTalk is a very expensive file manager and something like a scheduled task would be a better solution.

If there is additional processing, then I'd definitely go with boatsellers solution of just leaving the receive location enabled and having a copy process.

Cheers,

Martin

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator 1 hour 42 minutes ago

Hi Prakash,

Is there secondary processing of the files or is it literally pick up data in files, and move that data to another resource such as SQL Server?

If so, then SQL Server Integration Services could well be a better fit for this and you can schedule when the package runs easily.

If you are simply moving files around, BizTalk is a very expensive file manager and something like a scheduled task would be a better solution.

If there is additional processing, then I'd definitely go with boatsellers solution of just leaving the receive location enabled and having a copy process.

Cheers,

Martin

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator Monday, September 07, 2015 5:21 AM

Hi Prakash,

Is there secondary processing of the files or is it literally pick up data in files, and move that data to another resource such as SQL Server?

If so, then SQL Server Integration Services could well be a better fit for this and you can schedule when the package runs easily.

If you are simply moving files around, BizTalk is a very expensive file manager and something like a scheduled task would be a better solution.

If there is additional processing, then I'd definitely go with boatsellers solution of just leaving the receive location enabled and having a copy process.

Cheers,

Martin

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator Monday, September 07, 2015 5:21 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator 18 hours 35 minutes ago

Hi Prakash,

Is there secondary processing of the files or is it literally pick up data in files, and move that data to another resource such as SQL Server?

If so, then SQL Server Integration Services could well be a better fit for this and you can schedule when the package runs easily.

If you are simply moving files around, BizTalk is a very expensive file manager and something like a scheduled task would be a better solution.

If there is additional processing, then I'd definitely go with boatsellers solution of just leaving the receive location enabled and having a copy process.

Cheers,

Martin

• Proposed as answer by Angie xuMicrosoft contingent staff, Moderator Monday, September 07, 2015 5:21 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, September 08, 2015 12:26 PM