Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SQLXMLBulkLoad - How do I specify the database schema for ..

 
   Database Forums (Home) -> XML RSS
Next:  Auditing SQL Server  
Author Message
gaetan

External


Since: Jul 25, 2006
Posts: 1



(Msg. 1) Posted: Thu Feb 07, 2008 8:47 am
Post subject: SQLXMLBulkLoad - How do I specify the database schema for a table?
Archived from groups: microsoft>public>sqlserver>xml (more info?)

Hi,

If I prefix the table name with the schema it belongs to

Example:
sql:relation="LOYUS.BURN_REWARDS"

I get the error:

" Incorrect syntax near '.'. "

Evertything works fine if I change it to sql:relation="BURN_REWARDS"
but that creates it under the DBO schema.

PLEASE HELP, is it possible to specify table name with schema ?

g

 >> Stay informed about: SQLXMLBulkLoad - How do I specify the database schema for .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Xml Schema - How can I define the rule: "Element A must contain element B or element C or both elements" I write this: <xs:element name="A"> <xs:complexType> <xs:choice> <xs:element name="B" type="xs:st...

schema vs metadata - hello, I have a generic question. Are the terms Schema (or xml schema) the same as the term metadata? "Data that is used to describe other data. " Just wondering. Is it correct to switch between terms? or in xml do you always have to use the ...

XML Schema Problem (MSG 6928) - Hi, I'm trying to use an XML Schema, but get the following error message: Msg 6928, Level 16, State 2, Line 1 XML Validation: XML instances of the content model of type or model group 'photoType' can be validated in multiple ways and are..

Need Help with XML Schema for Bulkload - I've been struggling for days trying to create an XML View/Schema mapped to SQL Server to import a relatively straightforward XML document into a simple (only two tables) SQL Server database. The examples I've seen do not seem to address cases where..

Defining XML Schema - This is the format of my xml file. I have to upload this data into SQL Server. <spanfile> <pointInTime> <date>20070102</date> <isSetl>1</isSetl> <setlQualifier>final</setlQualifier> <clearingOrg> &...
   Database Forums (Home) -> XML All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]