Thanks Greg;
I was hoping to avoid having multiple receive locations for each provider. I was thinking of trying to manually assemble the flat files into xml, similar to how i imagine the flat file pipeline does it. Once i had it into XML i could then do the transforms dynamically.
Do think this approach will work?
Or should i just stick with multiple receive locations?