Input to SQL Adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Input to SQL Adapter

Viewing 1 reply thread
  • Author
    Posts
    • December 3, 2005 at 11:45 AM #12475
      community-content

        Hi,

        We are using SQL Adapter in biztalk orchestration and giving stored procedure to that SQl Adapter.

        I want to select 13-14 fields from database using SQL Adapter but want to give a shema of only one field. Is it possible to me?

        Or there is a need to give a input message to SQL Adapter related to fields in SELECT statement. Can we give different schema as input to SQL Adapter?.

        Thanks in advance

      • December 12, 2005 at 6:17 AM #12476
        community-content

          I have not worked with the SQL Adapter much. I do not know if what you are talking about is possible. The SQL Adapter is really there to return data to you.

          The best resource available is the SQL White Paper by Todd Uhl.
          You can get it here: http://msdn.microsoft.com/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp?frame=true&_r=1

          Hope this helps.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.