What tremendous service!
Just a few comments before I get back into it and see why that solution I sent did not fail for you. The first thing will be to unzip the file I sent you and make sure it fails for me.
We have something running on our network that (apparently) periodically deletes anything named “Backup Files” (and below) and a lot of my old code is gone this morning. I did not test the components I sent you for failure before sending them today. I do have copies; but was quite sure that I was sending the right package.
There are two reasons for using the OLE-DB command vs. destination. The destination does not work with remote hosts in this release, and there is no success output on a destination to allow the return trip from the destination back to the StageFlag in the source.
I have already taken Donald Farmer’s comments to heart and will be looking at his suggestions. And I will add Matt David’s suggestions to the list. I clearly see part two of this article coming.
More to follow… And thank you once again.