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