I am using xmlbulkload to import a large XML file into a SQL 2005 database. I have run into an issue when the data located in one of the XML elements exceeds the defined length on the SQL field. I was wondering if there is a way to annotate the element in the XSD so that the data is truncated prior to it being imported. below you will find the error I am receiving:
Error: Type of column 'ColumnName' in table 'TableName' is too small to hold data
Error: Type of column 'ColumnName' in table 'TableName' is too small to hold data