Don’t know how to start

#12485

I’ve played with it some more and no luck :). I have a receive ftp location which looks for a file on an ftp site which activates the orchestration. I want the orchestration to grab data from sql server table, mix the data with the data from the flatfile gotten on the ftp and then insert into another sql table. I dont know enough about biztlak to know where to start. I tried to create a paralell process which has two receive shapes which are connected to FTP Receive Loc and SqlServer respectively. Now It seems that i need to combine two messages into one and then try to map this 3rd composite message into a 4th one thats going to be sent to an SqlServer port? Do i need to create a schema which can hold both files separate under a root node and then MAP that schema into final result? Pretty confusing. By the way, i’ve used paralell process because it said that Two Receive Shapes in a convoy require them to have the same port….pretty weird. What’s a good way to procede? Obviously I am confused……Thanks