... into the table sample data (xml) is below: <?xml version="1.0" encoding="...<VER>1.1</VER> <FN>EAF1NL20080708.xml</FN> <DATE>20080708 14:07:59</... below in my dts package and xml schema, where I specify which sql ... "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success ...

...goes into the table sample data (xml) is below: <?xml version="1.0" encoding="... <VER>1.1</VER> <FN>EAF1NL20080708.xml</FN> <DATE>20080708 14:07:59</... below in my dts package and xml schema, where I specify which sql ....Execute "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success ...

...>1.1</VER> <FN>EAF1NL20080708.xml</FN> <DATE>20080708 14:07...in my dts package and xml schema, where I specify which...c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success...End Function schema ---------- <?xml version="1.0" encoding="utf-8"?> <xsd...

...<VER>1.1</VER> <FN>EAF1NL20080708.xml</FN> <DATE>20080708 14:07:59... below in my dts package and xml schema, where I specify which sql... "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success ...> End Function schema ---------- <?xml version="1.0" encoding="utf-8"?> <xsd:...

...<VER>1.1</VER> <FN>EAF1NL20080708.xml</FN> <DATE>20080708 14:07:59... below in my dts package and xml schema, where I specify which sql... "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success ...> End Function schema ---------- <?xml version="1.0" encoding="utf-8"?> <xsd:...

... <VER>1.1</VER> <FN>EAF1NL20080708.xml</FN> <DATE>20080708 14:07:59</DATE... below in my dts package and xml schema, where I specify which sql ...Execute "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success End Function schema ---------- <?xml version="1.0" encoding="utf-8"?> <xsd:schema ...

... I have the vbscript below in my dts package and xml schema, where I specify which sql table field the data would ...:\error.log" objBulkLoad.Execute "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success End Function schema ---------- <?xml version="1.0" encoding="utf-8"?> <xsd:schema id="EAF1NL" xmlns:xsd="http...

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 - ... = "c:\error.log" objBulkLoad.Execute "c:\EAF1NL.xsd", "c:\EAF1NL.xml" Set objBulkLoad = Nothing Main = DTSTaskExecResult_Success End Function schema ---------- <?xml version="1.0" encoding="utf-8"?> <xsd:schema id="EAF1NL" xmlns:xsd="http://www.w3....

...Maybe there are compatibility problems with XML data-types and SQL...dbo.usp_fix_xsd 'C:\...\Genome\original_schema1.xml' ------------------------------------------------------------------------------------------------ CREATE PROC dbo.usp_fix_xsd @filepath...INT SET @i = 0 WHILE @xml.exist( '(//xs:element[@type = "xs...IF @debug_yn = 1 -- Inspect the XML afterwards SELECT 'After' AS source...

...Execute "c:\XMLfileschema.xsd", "c:\XMLFile.xml" Set objBulkLoad = Nothing MsgBox "Done." "... Hi in the schema I have ------------------------ <?xml version="1.0" encoding="utf-8... reference to the schema in the XML file? Thanks "Martin Honnen" wrote: ...> jojo123 wrote: I'm using xml bulkload using sql server 2000. The XML files are dependent on an xsd...