Sign in
 
HomeLibraryLearnDownloadsSupportForums
Resources for IT Professionals > Forums Home > BizTalk Server Forums > BizTalk Server Adapters and Adapter Pack > SQL Adapter
Ask a questionAsk a question
Search Forums:
 

QuestionSQL Adapter

  • Saturday, September 12, 2009 10:55 AMDanishLko Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I have two select statements in my stored procedure, now when i generate a schema using sql adapter i am getting the schema for the first select statement only and not for the second. How to resolve this.
     

All Replies

  • Sunday, September 13, 2009 5:19 PMBen Cline1MVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Try moving both statements into a stored procedure and having the stored procedure be the source you generate the schema on. You may not be able to run a batch of statements from the port.

    Thanks,
    If this answers your question, please use the "Answer" button to say so | Ben Cline
     
  • Monday, September 14, 2009 6:22 AMDanishLko Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Please read my question again, i have mentioned that i already have a Stored procedure with two select statements in it. Now the issue is that the schema that is getting generated is having fields specified in the first select statement only while for the second select the schema is not having anything.

     
  • Tuesday, September 15, 2009 7:12 PMAlex Krotov Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Try wrapping the first select statement in a separate stored procedure.  Then call this new stored procedure inside your main sp in place of the first select statement.  If it works, please mark as an answer.
     
  • Friday, September 18, 2009 7:42 PMKerrey ZhengMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Use Join / Temp DB instead.
    Kerrey [BizTalk Consultant]
     
  • Tuesday, September 22, 2009 11:31 AMAbhinavp Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Which SQL adapter are you using ? Is it the SQLXML based adapter which shipped with BizTalk server 2006/R2 or is this the WCF based SQL Adapter shipped with BizTalk Adapter Pack 2.0 ?
    Abhinav