I have namspace problem in Bulkload where if in XML data file, I have
a namespace like xmlns='urn:TMSWebServices', then in my schema I must
put xmlns:tm="urn:TMSWebServices" right?

but if I put that, then I will not able to use Bulkload as it say
tm:callSign has invalide charater.

How can I deal with namespace like xmlns='urn:TMSWebServices' in data
file?

XML schema:
Code Snippet
=============================
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
  xmlns:tm="urn:TMSWebServices">

  <xsd:element name="tm:station" sql:relation="station">
     <xsd:complexType>
        <xsd:sequence>
           <xsd:element name="tm:callSign" type="xsd:string"/>
           <xsd:element name="tm:name" type="xsd:string"/>
           <xsd:element name="tm:affiliate" type="xsd:string"/>
        </xsd:sequence>
        <xsd:attribute name="tm:id" type="xsd:integer"/>
     </xsd:complexType>
  </xsd:element>
 
</xsd:schema>

XML data:
=============================

<xtvd xmlns='urn:TMSWebServices' >

         <stations>
           <station id='46719'>
             <callSign>52MXI</callSign>
             <name>Canal 52MX International</name>
             <affiliate>Satellite</affiliate>
           </station>
           <station id='19327'>
             <callSign>70S</callSign>
             <name>Music Choice: 70&apos;s</name>
             <affiliate>Music</affiliate>
           </station>
           <station id='19328'>
             <callSign>80S</callSign>
             <name>Music Choice: 80&apos;s</name>
             <affiliate>Music</affiliate>
           </station>
         </stations>

</xtvd>

SQL Table:
=============================

CREATE TABLE ProgramListings.dbo.station)

(
id  INT,
callSign VARCHAR(20),
name VARCHAR(100),
affiliate VARCHAR(100),
PRIMARY KEY(id)

)