mercredi 15 juin 2016

Invalid column name importing from XML to SQL

I'm getting an error trying to import a XML file to SQL. The code looks like this:

USE MyDB

declare @xmldata as xml

set @xmldata = (SELECT CONVERT(XML, BulkColumn)AS Bulkcolumn
FROM OPENROWSET (BULK 'FILENAME', SINGLE_BLOB) as X)

INSERT INTO BenCalCopy1(BenefitCalcID, RangeBenID, CalculationID)
SELECT 

BenefitCalcID AS [BenefitCalcID],
RangeBenID AS [RangeBenID],
CalculationID AS [CalculationID]

The error message given is:

Msg 207, Level 16, State 1, Line 11
Invalid column name 'BenefitCalcID'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'RangeBenID'.
Msg 207, Level 16, State 1, Line 13
Invalid column name 'CalculationID'.
Msg 207, Level 16, State 1, Line 8
Invalid column name 'BenefitCalcID'.

And the XML File is given as:

<row>
  <BenefitCalcID>'intvalue'</BenefitCalcID>
  <RangeBenID>'intvalue'</RangeBenID>
  <CalculationID>'intvalue'</CalculationID>
</row>

Aucun commentaire:

Enregistrer un commentaire