SqlBulkCopy Tutorial - Knowledge Base (KB)

XSD: type of column x in table y is too small to hold data

I am generating an XSD file based on the columns in my xml. I give them all the type, "xs:string". Then I try to import the file into my database using .NET with SQLbulk import, but for some fields are to small. I get the message, "type of column x in ta...

Get a valid schema of large (1 GB) xml files

I need to bulk load huge xml files to SQL Server 2005. I decided to use SQLXMLBULKLOAD in my C# app, but I need to get valid xsd-schemas of those xml files to load them. Which is best way to generate xsd file? I tried MS VS xsd.exe, but it tries to load t...

Pattern matching on xsd:element name

I am using SQL XML bulk load to inject the data direct to the database. My XML and xsd are as the following:...XML:...<?xml version="1.0"?> <Data> <USEFUL> <Value>3.1</Value> <Date>12/20/2001</Date> </USEFUL> <Something> <V...