Well, Gee...

So, at work I've been trying to get a BizTalk solution together- both to alleviate some actual pain points and as a 'proof of concept' and it's been a real pain in the donkey. It took much longer than it should have to get BizTalk installed and configured, but we finally did it, and now I'm actually coding the solution. Yipee for me. Mostly it's going ok, but I keep running into things which make me wish (again) that I had some kind of formal training. I'm sure these questions are basic, BizTalk 101 type questions, but I can't find the answers anywhere- or, at least, not illustrated well enough to teach the concept. So, dear reader, I'm wondering if you can help me. Below is my list of "Man I wish I knew" for BizTalk:

• how to: evaluate the inbound filename of a file and make a decision based on that
• how to: establsih and use a Send Port Group
• if multiple send groups are necessary for different types of send ports (e.g. SQL Adapter vs. FILE)
• best practice for sending results to SQL for update, and archive file to seperate folder.
• how to: use SQL Send Adapater
• how to: set up SQL Stored Procedure to INSERT or UPDATE DB instead of only querying
• how to: Configure a .NET assembly/class for use with BizTalk and call it from an orchestration