- This topic has 1 reply, 1 voice, and was last updated 9 years, 6 months ago by
.
-
Posts
-
-
Does anyone know which file system event(s) the file receive adapter uses to detect new files in a folder?
I've got a situation where files are being created by a SQL 2000 DTS package Text File Destination task on another Windows 2003 server. I'm then using the BizTalk 2006 File adapter to read the files in from a network share. Every now and then BizTalk seem to read in an empty file, as though it sees the file being created and starts processing it before DTS gets round to writing the data to the file. The file usually contains only a few lines and they are pretty beefy servers I'm running it on so I can't see how this could be happening. Any ideas?
-
Hi Anonymous,
I can't say this authoritatively, but the polling for Windows is advanced and it is tied to the format of the file system.
In NTFS, there is a FileChangeNotificationEvent that effectively allows the event to be "pushed" rather than doing the repetitive work of traditional polling.
I don't know that this helps. What we commonly do in old-school architecture is to "stage" the file – i.e. write it as a temp filename that doesn't trip the trigger and as the last step we rename the temp file to a trigger name.
With NTFS, like I mentioned, you shouldn't have to do this, it should not produce the event until the file is closed. But maybe DTS is opening and closing it consecutively instead of opening at the beginning and closing at the end? Hard to say without looking at the package.
– weak architect
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.