Problems with xml bulkload
Mon, 7 Jul 2008 05:16:08 -0700
Hi
I have the vbscript below in my dts package and xml schema, where I specify
which sql table field the data would go into - whilst I don't get any errors
- there's no data going into the table - it's completely empty - any ideas?
I'm trying to load the data into a single table
VB Script :
Functio ...
|
newbie to xpath/xquery trying to pull email address out of xml in
SSRS subscription table
Thu, 3 Jul 2008 13:11:03 -0700 (PDT)
i'm trying to pull out email addresses info from the SSRS subscription
table. The xml looks like this:
<ParameterValues>
<ParameterValue>
<Name>TO</Name>
<Value>pep1@myemail.com;pep2@myemail.com</Value>
</ParameterValue>
<ParameterValue>
<Name>BCC</Name>
<Value>pep3@myemail.com;pep4@myemail.co ...
|
Change XML Attribute value with SQL XML DML/XQuery?
Fri, 27 Jun 2008 14:37:15 -0700 (PDT)
Is it possible to change an attribute value using XQuery? I
understand how to use "modify" to change an Element value, but can you
change an Attribute value?
For example, let's say I have the following:
<Books>
<Book id="1" category="food">Eat Me</Book>
<Book id="2" category="sports">Try a Tri(athlo ...
|
SQL to XML question
Sun, 22 Jun 2008 11:04:50 GMT
Hi SQL/XML experts.
I'm building a query that creates a XML output.
select name,place,salary from consert,artist
where consert.artid =artist.artid
for XML RAW ('artistname'),root('payment_details'),ELEMENTS
This produces the output:
<payment_details>
<artistname>
<navn>Michael Jackson</navn>
...
|
loading xml data into sql server relational db
Wed, 18 Jun 2008 14:00:03 -0700
using example from http://support.microsoft.com/kb/316005 with a small
change...
How do I modify customermapping.xml to populate the Sourcefile field in
Customer table with "customers.xml" i.e. the name of the source file from the
tag: <Filename>customers.xml</Filename>
thanks much
customers.xml:
<ROOT>
...
|
Permissions problem configuring virtual directory SQLXML
Tue, 17 Jun 2008 11:42:25 +0100
Hi
I'm using SQL2000 on a Win2K server.
I am having some difficulty configuring the security on the virtual
directory for SQLXML
I am using the "Configure SQL XML Support in IIS" utility supplied, which
has worked perfectly with other installations. On this installation, I can
make it work by setting "A ...
|
FOR XML PATH node element containing "<" character
Mon, 16 Jun 2008 12:59:04 -0700 (PDT)
I want my result set to include the "<" character within the node
element name however the sql compiler is returning an invalid
character err. msg. ("..contains an invalid XML identifier as required
by FOR XML; '''(0x0027) is the first character at fault."). I've
tried to use the "<" however that's not worki ...
|
|
|
sql:relation and sql:field
Fri, 13 Jun 2008 13:39:22 -0300
hi
a have a "code" element in my schema
this element maps to the "client" table (wich PK is "client_id" )
i need to get, for a specific node
the whole xml but adding the "client.name" field
without having to write any specific code in the query
thus, i just store the "code"
and later, i will retrieve the ...
|
SELECT .... FOR XML and data alignment in the table
Thu, 12 Jun 2008 13:08:36 -0700 (PDT)
This is taken from SQL 2005 help from sp_send_dbmail article:
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<H1>Work Order Report</H1>' +
N'<table border="1">' +
N'<tr><th>Work Order ID</th><th>Product ID</th>' +
N'<th>Name</th><th>Order Qty</th><th>Due Date</th>' +
N'<th>Expe ...
|
Create XML, first line
Mon, 9 Jun 2008 05:55:41 -0700
How do I add <?xml version="1.0" encoding="UTF-8"?> to the first line of the
output from this query?
select 1 as TAG, NULL as Parent, xx as [variable!1!name], yy as
[variable!1!!element] FROM zz for XML EXPLICIT, ROOT('test')
Thanks!
...
|
