SQL Adapter Schema mapping

Hi,

   I am using SQl adapter to pull records from a sql server table with simple select statement. Adapter generates its own schema. Now, I want to map this autogenerated schema to anothe schema for some processing. I am not able to do that. I just tried. orch. does not shows any error and their are no results. 

I am pasting SQl adapter generated schema for ref.

Sql schema XSD is

<?xml version=”1.0″ encoding=”utf-16″?>
<xschema xmlns:b=”http://schemas.microsoft.com/BizTalk/2003” attributeFormDefault=”unqualified” elementFormDefault=”qualified” targetNamespace=”http://Time_Sheet” version=”1.0″ xmlns:xs=”http://www.w3.org/2001/XMLSchema“>
  <xs:annotation>
    <xs:appinfo>
      <msbtssqlqlScript value=”SELECT Client_Name,Convert(nvarchar,TS_Date,101)as date,Hours,TS_Descr,TS_User FROM dbo.Time_Sheet as TS Inner Join dbo.TS_Client as TSC ON TS.Client_Id = TSC.Client_ID AND trnsfr=0 for XML AUTO, ELEMENTS” xmlns:msbtssql=”http://schemas.microsoft.com/BizTalk/2003” />
      <schemaInfo is_envelope=”yes” xmlns=”http://schemas.microsoft.com/BizTalk/2003” />
    </xs:appinfo>
  </xs:annotation>
  <xs:element name=”TS”>
    <xs:annotation>
      <xs:appinfo>
        <recordInfo body_xpath=”/*[local-name()=’TS’ and namespace-uri()=’http://Time_Sheet’%5D/*%5Blocal-name()=’TSC&#8217; and namespace-uri()=’http://Time_Sheet’%5D&#8221; xmlns=”http://schemas.microsoft.com/BizTalk/2003” />
      </xs:appinfo>
    </xs:annotation>
    <xs:complexType>
      <xsequence>
        <xs:element xmlns:q1=”http://Time_Sheet” minOccurs=”0″ maxOccurs=”1″ name=”TSC” type=”q1:TSCType” />
      </xsequence>
    </xs:complexType>
  </xs:element>
  <xs:complexType name=”TSCType”>
    <xs:choice minOccurs=”0″ maxOccurs=”unbounded”>
      <xs:element xmlns:q2=”http://Time_Sheet” maxOccurs=”unbounded” name=”TS” type=”q2:TSType” />
      <xs:element xmlns:q3=”http://Time_Sheet” name=”Client_Name” type=”q3:Client_NameType” />
      <xs:element xmlns:q4=”http://Time_Sheet” name=”date” type=”q4ateType” />
    </xs:choice>
  </xs:complexType>
  <xs:complexType name=”Client_NameType”>
    <xsimpleContent>
      <xs:extension base=”xstring” />
    </xsimpleContent>
  </xs:complexType>
  <xs:complexType name=”dateType”>
    <xsimpleContent>
      <xs:extension base=”xstring” />
    </xsimpleContent>
  </xs:complexType>
  <xs:complexType name=”TSType”>
    <xs:choice minOccurs=”0″ maxOccurs=”unbounded”>
      <xs:element xmlns:q5=”http://Time_Sheet” name=”Hours” type=”q5:HoursType” />
      <xs:element xmlns:q6=”http://Time_Sheet” name=”TS_Descr” type=”q6:TS_DescrType” />
      <xs:element xmlns:q7=”http://Time_Sheet” name=”TS_User” type=”q7:TS_UserType” />
    </xs:choice>
  </xs:complexType>
  <xs:complexType name=”HoursType”>
    <xsimpleContent>
      <xs:extension base=”xshort” />
    </xsimpleContent>
  </xs:complexType>
  <xs:complexType name=”TS_DescrType”>
    <xsimpleContent>
      <xs:extension base=”xstring” />
    </xsimpleContent>
  </xs:complexType>
  <xs:complexType name=”TS_UserType”>
    <xsimpleContent>
      <xs:extension base=”xstring” />
    </xsimpleContent>
  </xs:complexType>
</xschema>

I am really trying hard for mapping this schema to another.

Any suggestions is more then welcome.

Thank you in advance.