title: How do you read a row of sql server db data from a biztalk orchestration?
body: <p>This is going to seem like a stupid question but I am just getting started with biztalk server 2013 R2 and need some help.  I have a fairly basic understanding of how the system works and was able to follow the msdn tutorial to create a biztalk app that moves a file from one folder, reads it and saves to another folder base on values in the file.</p>
  
  <p>What I am really trying to do now is the following.  When I recieve a value, I use that value as a key to read data from a sql server table and transform that data into another format for saving/transporting elsewhere.</p>
  
  <p>For the life of me I cannot find how to do the sql server portion of it.  I know you are supposed to install the adapter pack (done) and add a Consume Adapter Service and I have done that...but I don't figure out how to connect the orchestration to read the data from SQL.</p>
  
  <p>If you someone could point me to a comprehensive tutorial or maybe even recommend a book that I could buy that would be fantastic.</p>
  
  <p>Thanks</p>