sql data adapter ports RRS feed

  • Question

  • I have a biztalk project where I have successfully created my sql data adapter schemas.  What I am trying to do now is wire them up to ports and am having trouble finding a clear answer.  We are inserting data into a sql server database and returning the primary key generated from the insert, so I have a request and response schema therefore I also have a 2 way port.  I am confused on the general settings to configure this to have it point to the appropriate sql server and db.  Do I transmit via HTTP and just have the uri be the ip address of the sql server?
    Thursday, January 29, 2009 6:30 PM


  • Hi,

    For the SQL send port you set three things:

    • The database connection string
    • The target namespace of the schema
    • The root record name of the response message

    The stored procedure is determined by the name of the record in the reuqest message.

    There is a good walkthru on this here:





    • Proposed as answer by Mikael HåkanssonMVP Friday, January 30, 2009 5:02 PM
    • Marked as answer by ahager Friday, January 30, 2009 8:30 PM
    Thursday, January 29, 2009 6:41 PM