ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
I want to import xml data using SSIS. I tried using XML source in SSIS. 
 
But before loading into table I want to validate if the xml file matches 
 
correctly with the .xsd file. How can I do this? 
 
If instead of SSIS stored procedure is better approach then let me know. 
 
Thanks!

Hello, 
 
I am using the SQL Server 2005 Bulk Loader 
 
(SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class) in a VB .NET application to load 
 
data from an XML file into a SQL Server 2005 database . The application 
 
executes without error, but there no data are added to the database. I tested 
 
the app on a simple XML schema and data file that I downlodaed from MSDN, and 
 
that XML was loaded into the database, so I know the application works 
 
correctly. 
 
Any idea how I can determine why the Bulk  ...

[Announce] Webinar: Building XML Applications with Stylus Studio 2006 
 
This Wednesday, August 23, 2006, Join the Stylus Studio team for a 
 
special presentation on how to use Stylus Studio's powerful XML 
 
development tools along with new XQuery components from DataDirect 
 
Technologies to simplify the development and deployment of your XML 
 
applications, including data integration, Web publishing and more! 
 
Wed. Aug. 23 - 8:00AM Eastern Standard Time (EST) 
 
Wed. Aug. 23 - 2:00 PM Eas ...

-- The following query (without the SUM function) returns multiple records, 
 
-- each record being the PRODUCT of 2 numbers in each original xml record. 
 
-- How can I SUM these resulting records? 
 
-- Adding a SUM function, as shown below, does NOT work. 
 
-- Thanks, Paul 
 
SELECT	SUM( 
 
(FormXML.query(' 
 
for $a in (/transactionPricePerShare/value) 
 
for $b in (/transactionShares/value) 
 
return ($a * $b) 
 
')) 
 
AS transactionValues 
 
) 
 
FROM		SEC_Daily_Index 
 
WHERE		(FormType = '4')

I have very limited experience with SQL, and even less with XML or ASP, so 
 
I'm sorry if this is a silly question. I did search pretty extensively for a 
 
solution on numerous forums & groups and could find no answer. 
 
First a little background: 
 
I'm runnung SQL Server 2000, and IIS 6.0. 
 
I've written a stored procedure that accepts 3 required parameters, and 
 
outputs XML. I'm calling the SP using an XML template, and transforming the 
 
resulting XML document using an XSL stylesheet, ...

Hello, 
 
In the following SP, is it possible to use a query in the WITH clause 
 
to pull all of the attributes from the SalesInvoice element instead of 
 
explicitly naming them all, so that I could have a single, generic 
 
stored procedure that can take any XML, a Table name, and the element 
 
name containing the fields to shred as params and shred it? 
 
DECLARE @doc xmlSET @doc = '<?xml version="1.0" ?> 
 
<SalesInvoice InvoiceID="1000" CustomerID="123"OrderDate="2004-03-07"> 
 
< ...

I am receiving less then optimal performance results updating an xml column 
 
using SQL Server 2005. 
 
I have the following table: 
 
CREATE TABLE [dbo].[eSSApplication]( 
 
[AppSeqno] [numeric](18, 0) NOT NULL, 
 
[XMLApplication] [xml] NOT NULL, 
 
[DateTime_Modified] [datetime] NOT NULL, 
 
CONSTRAINT [PK_eSSApplication] PRIMARY KEY CLUSTERED 
 
( 
 
[AppSeqno] ASC 
 
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] 
 
) ON [PRIMARY] 
 
I have the following stored procedure to perform updates: 
 
 ...

Hello, 
 
given the following fragment of an XML document stored in an xml 
 
column 
 
<fields> 
 
<field fieldname=”LastName” changeId=”932749324” >Smith</field> 
 
<field fieldname=”FirstName” changeId=”932749324” >Bob</field> 
 
<field fieldname=”City” changeId=”932749324” >Chicago</field> 
 
<field fieldname=”State” changeId=”932749324” >IL</field> 
 
<field fieldname=”Phone” changeId=”932749324” >888-555-1212</field> 
 
</field> 
 
Is it possible to crea ...

Hi All, 
 
I'm trying to import following XML file into SQL without any success. Could 
 
you help me with this and could you describe the steps how importing this 
 
file. I can't use OPENXML as the XML file is over 8000. File can be with or 
 
without XSD schema and I'm not sure which one is better. Please help!!! 
 
My XML file is: 
 
--=================================================== 
 
<return xmlns="urn:schemas-microsoft-com:xml-analysis"> 
 
<root xmlns="urn:schemas-microsoft-com ...

I have a couple of complete beginner questions that hopefully someone 
 
can help with. 
 
Scenario: 
 
I want to store an XML document from an application into an xml field. 
 
On insert and update of the xml data into this column, I want to run a 
 
stored procedure that will parse out certain key fields values and 
 
store them in other columns of the table (to facilitate reporting and 
 
other querying (I can probably use views into the xml constructed with 
 
XQuery for this, but I'm not th ...

Few months ago we used sybase database. 
 
I could export some data (xml) from field to a file width query: 
 
SELECT xp_write_file('\\Renatopc\Razvoj\EUR_test_renato.xml') FROM 
 
"client"."Documents" where iddoc=4985 
 
Now we cant find the same query on Microsoft SQL...

I am trying to explain my scenario below. 
 
To get data from tables A (Columns ColA1, ColA2), B (Columns ColB1, ColB2) 
 
and C (Columns ColC1, ColC2) and display it in xml in format below. 
 
<Root> 
 
<TableData> 
 
<A> 
 
<GroupA_1> 
 
<A_Col1> 
 
</A_Col1> 
 
</GroupA_1> 
 
</A> 
 
<B> 
 
<GroupB_1> 
 
<B_Col1> 
 
</B_Col1> 
 
</GroupB_1> 
 
<GroupC_1> 
 
<C_Col1> 
 
</C_Col1> 
 
</GroupC_1> 
 
</B> 
 
</TableData> 
 
</Root> 
 
I  ...

I have SQLXML add the inline schema using the XMLSCHEMA keyword. 
 
I iterate the elements in a row but the XmlType property of the nodes is 
 
null.. 
 
This may be more a .NET XML question but I thought I'd try here first. 
 
Chris

We are trying to run a XQuery/XPath in SQL Server 2005 against a 
 
Reporting Services DSV file that is kind of half xml doc and half 
 
schema(xsd), and the query will only return null because the attribute 
 
we are trying read has a namespace before it.  We are stumped!!! 
 
Here is the background: The DSV file was uploaded to an un-typed XML 
 
datatype field with bulkloader to be queried. 
 
Here is an example query: 
 
Select xmlcol.query(' 
 
declare namespace msprop = "urn:schemas-micros ...

Hi, 
 
I have an XML coumn with below XML Doc 
 
<WebSRFTemplate Version="1" Type="ACCESS" Product="DSL"> 
 
<Data> 
 
<Field Name="ACCESSAEndSiteID">287</Field> 
 
</Data> 
 
</WebSRFTemplate> 
 
When I run below Update Statement 
 
UPDATE tbl_access 
 
SET access_detail.modify('declare namespace 
 
my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-10-15T18:10:59"; 
 
replace value of (//WebSRFTemplate/Data/ACCESSAEndSiteID)[1] 
 
with "Test"') 
 
WHERE access_i ...

Hi there, 
 
I'm using SQLXML 3 and I'm currently trying to speed up XPath requests 
 
by using sql:datatype on the Schema. Unfortunately this stops the 
 
updategram working as I'm using xsd:date and setting 
 
sql:datatype="dateTime" will then results in: 
 
"The value '2006-8-7' is not a valid date/time value". 
 
And so the insert fails. 
 
Of course I can get rid of sql:datatype="dateTime" and it will work ok 
 
but I read that this can really improve performance. Adding T00:00:00 
 
might  ...

Hello, 
 
I'm using an application that produces an xml document and I'd like to learn 
 
how to use t-sql to import it into a table. 
 
The document looke like this in Notepad: 
 
<?xml version="1.0" encoding="UTF-8"?> 
 
<TRANS_STANDARD> 
 
<MSH> 
 
<SendingApplication>LAB</SendingApplication> 
 
<MessageDateTime>08/04/2006 07:53</MessageDateTime> 
 
<MessageTypeID>ORU</MessageTypeID> 
 
</MSH> 
 
<PID> 
 
<PatientID_Internal>00001475603</PatientID_Intern ...

Hi folks, 
 
I found diificulty in using typed xml in SQL Server 2005. 
 
- Creating a schema collection --> OK 
 
- Declaring a xml variable by associating to the schema collection --> 
 
OK 
 
- Assigning a xml document to the variable --> NOT OK 
 
Enclosed is the script and the err msg. What's wrong? Please help! 
 
Thanx & regards, 
 
Feri 
 
USE [AdventureWorks] 
 
GO 
 
CREATE XML SCHEMA COLLECTION MyNote AS 
 
N'<?xml version="1.0"?> 
 
<xs:schema xmlns:xs="http://www.w3.org/2001/X ...

I have a stored procedure that draws data from an EPR system with many 
 
rows. The ERP system uses "" as a kind of null indicator in the sql 
 
tables. 
 
My problem is that I would like mssql to return a valid xml document 
 
(using for xml explicit) - without the "" in the places where no data 
 
exists. 
 
This is easily done by replacing the "" with an empty character or 
 
null but the problem is that performance declines heavily when I use 
 
replace on the different fields. 
 
the pro ...

Hello All, 
 
My queries are as follows: 
 
1)  How much memory is consumed by the XML Dataype column when initially? 
 
2)  In what scenario should we XML Datatype? 
 
Personal Information 
 
Key 
 
Name 
 
Address 
 
FriendsList 
 
BankAccounts 
 
PhoneNo 
 
Name 
 
PhoneNo 
 
BankName 
 
AccountNo 
 
3)  If I have a scenario like above which option should I use? 
 
Option 1: Make three different tables Named Main, FriendsList and 
 
BankAccounts 
 
Header table named Main 
 
PersonalKey 
 
Na ...

When I query using FOR XML, query analyzer always returns some kind of ID 
 
code prior to the query results, e.g.: 
 
XML_F52E2B61-18A1-11d1-B105-00805F49916B 
 
<Schema name="Schema7" xmlns="urn:schemas-microsoft-com:xml-data" 
 
xmlns:dt="urn:schemas-microsoft-com:datatypes"> 
 
<ElementType name="Northwind..Employees" content="eltOnly" model="closed" 
 
order="many"> 
 
<element type="firstname"/> 
 
<element type="lastname"/> 
 
<element type="employeeid"/> 
 
</ElementTyp ...

I am in the process of developing an import procedure. This procedure will 
 
take a flat file then bcp it into a pre-defined temp\working table. The 
 
tables columns are going to be varchar (250) for example. I've got to get the 
 
file's content into a table if the data's properly delimited. Meaning I don't 
 
want the import to fail on a data type validation. Ok, so now my flat file 
 
has been imported to the temp\wokring table. (This table has 450+ columns.) 
 
So now I need to do the foll ...

We have a client that is using SQLXMLbulkLoad.  The process actually 
 
loads multiple xml files at a time.  Recently they started receiving 
 
the following error: 
 
"SQL Server does not exist or access denied" 
 
This error only happens on every 60th xml load file (i.e. if they're 
 
are 130 xml files to load, when sqlxmlbulkload executes/loads the 60th 
 
and 120th file, this error displays, and so on... every 60th file). 
 
Does anyone have any idea what could be causing this issue?

Hello, 
 
I first posted this Question in the XML newsgroup but as somebody suggested 
 
this could be the much better place for it. 
 
So my Question again: 
 
I have some issues in creating an XQuery Statement in an SQL Server 2005 
 
Database. 
 
I require to create a query which selects a resultset of data in a non case 
 
seneitive manner in combination with the usage of the contains()-Function, 
 
for example like that: 
 
SELECT * FROM tblObjects WHERE XMLFields.value(' 
 
contains( (/all ...

I have a problem. 
 
We have a requirement to transform an xml document with xslt. 
 
We have an include line which includes a function from an external text file : 
 
<xsl:include 
 
href="C:\sourcecode\SourceSafe\Development\Inventory\DataLoad\Source\Resources\Postar_Functions_Strings.xslt"/> 
 
When this function is stored externally, the XML task comes up with a 
 
message 'xslt compile error'. If we take this code out and put it at the 
 
bottom of the xslt, the ssis package works fine. 
 
Has anyone ever come across this ? 
 
Thanks.