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