That’s exactly my problem, there’s nothing in the data to relate it, since I need to join the data without a condition. I am not dropping the files on the FTP, the other company is. This process runs every day. Do you think if i put a Fixed value for ID, for example value=1. So both the schemas will have promoted ID field with Value of 1 and correlate on that maybe……is there an OrchestrationInstanceID variable somewhere? Because in my process, I am waiting for a file on ftp, once I got the file, i select data from SQL Server and JOIN it with the data from FTP. It’s kinda like a step by step process, so I have nothing to link it with, although OrchestrationInstanceID would be ideal, if there’s such a thing…..
the format of the files is described here: http://www.biztalkgurus.com/forums/viewtopic.php?t=213
Thanks