Does this change work?

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

<worlman385@yahoo.com> wrote in message
news:q7ouu3p1h2sc3etsgvrneu6obkdli6llp5@4ax.com...
>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)
>
> )