Namespace problem in Bulkload

Namespace problem in Bulkload

am 30.03.2008 11:45:13 von worlman385

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
=============================
xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
xmlns:tm="urn:TMSWebServices">














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





52MXI
Canal 52MX International
Satellite


70S
Music Choice: 70's
Music


80S
Music Choice: 80's
Music





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

CREATE TABLE ProgramListings.dbo.station)

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

)

Re: Namespace problem in Bulkload

am 30.03.2008 19:22:46 von xyz

Does this change work?

xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
xmlns:tm="urn:TMSWebServices"
xmlns="urn:TMSWebServices">

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
> =============================
> > xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
> xmlns:tm="urn:TMSWebServices">
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> XML data:
> =============================
>
>
>
>
>
> 52MXI
> Canal 52MX International
> Satellite
>
>
> 70S
> Music Choice: 70's
> Music
>
>
> 80S
> Music Choice: 80's
> Music
>
>
>
>
>
> SQL Table:
> =============================
>
> CREATE TABLE ProgramListings.dbo.station)
>
> (
> id INT,
> callSign VARCHAR(20),
> name VARCHAR(100),
> affiliate VARCHAR(100),
> PRIMARY KEY(id)
>
> )

Re: Namespace problem in Bulkload

am 31.03.2008 01:36:03 von worlman385

use


xmlns:sql="urn:schemas-microsoft-com:mapping-schema"

xmlns:tm="urn:TMSWebServices"

targetNamespace="urn:TMSWebServices"

elementFormDefault="qualified">



On Sun, 30 Mar 2008 13:22:46 -0400, "Mike C#" wrote:

>Does this change work?
>
> > xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
> xmlns:tm="urn:TMSWebServices"
> xmlns="urn:TMSWebServices">
>
> 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
>> =============================
>> >> xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
>> xmlns:tm="urn:TMSWebServices">
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> XML data:
>> =============================
>>
>>
>>
>>
>>
>> 52MXI
>> Canal 52MX International
>> Satellite
>>
>>
>> 70S
>> Music Choice: 70's
>> Music
>>
>>
>> 80S
>> Music Choice: 80's
>> Music
>>
>>
>>
>>
>>
>> SQL Table:
>> =============================
>>
>> CREATE TABLE ProgramListings.dbo.station)
>>
>> (
>> id INT,
>> callSign VARCHAR(20),
>> name VARCHAR(100),
>> affiliate VARCHAR(100),
>> PRIMARY KEY(id)
>>
>> )
>