- SQL code
CREATE TABLE [dbo].[TempTrans]( [TransactionsDate] [nvarchar](max) NULL, [PosNumber] [nvarchar](max) NULL, [AccountNumber] [nvarchar](max) NULL, [CardNumber] [nvarchar](max) NULL, [TransType1] [nvarchar](max) NULL, [TransType2] [nvarchar](max) NULL, [TransType3] [nvarchar](max) NULL, [TransAmount] [nvarchar](max) NULL, [TransType4] [nvarchar](max) NULL, [TransType5] [nvarchar](max) NULL, [TransType6] [nvarchar](max) NULL, [TransType7] [nvarchar](max) NULL, [TransType8] [nvarchar](max) NULL, [TransType9] [nvarchar](max) NULL, [TransType10] [nvarchar](max) NULL, [TransType11] [nvarchar](max) NULL, [TransType12] [nvarchar](max) NULL, [TransType13] [nvarchar](max) NULL, [TransType14] [nvarchar](max) NULL, [TransType15] [nvarchar](max) NULL, [TransType16] [nvarchar](max) NULL, [TransType17] [nvarchar](max) NULL, [TransType18] [nvarchar](max) NULL, [TransType19] [nvarchar](max) NULL, [TransType20] [nvarchar](max) NULL, [TransType21] [nvarchar](max) NULL, [TransType22] [nvarchar](max) NULL, [TransType23] [nvarchar](max) NULL, [TransType24] [nvarchar](max) NULL, [TransType25] [nvarchar](max) NULL, [TransType26] [nvarchar](max) NULL, [TransType27] [nvarchar](max) NULL, [TransType28] [nvarchar](max) NULL )
test.xml
- XML code
<?xml version="1.0"?><BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <RECORD> <FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="3" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="4" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="5" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="6" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="7" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="8" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="9" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="10" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="11" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="12" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="13" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="14" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="15" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="16" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="17" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="18" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="19" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="20" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="21" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="22" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="23" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="24" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="25" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="26" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="27" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="28" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="29" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="30" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="31" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="32" xsi:type="CharTerm" TERMINATOR="\t" COLLATION="Chinese_PRC_CI_AS"/> <FIELD ID="33" xsi:type="CharTerm" TERMINATOR="\r\n" COLLATION="Chinese_PRC_CI_AS"/> </RECORD> <ROW> <COLUMN SOURCE="1" NAME="TransactionsDate" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="2" NAME="PosNumber" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="3" NAME="AccountNumber" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="4" NAME="CardNumber" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="5" NAME="TransType1" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="6" NAME="TransType2" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="7" NAME="TransType3" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="8" NAME="TransAmount" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="9" NAME="TransType4" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="10" NAME="TransType5" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="11" NAME="TransType6" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="12" NAME="TransType7" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="13" NAME="TransType8" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="14" NAME="TransType9" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="15" NAME="TransType10" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="16" NAME="TransType11" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="17" NAME="TransType12" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="18" NAME="TransType13" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="19" NAME="TransType14" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="20" NAME="TransType15" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="21" NAME="TransType16" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="22" NAME="TransType17" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="23" NAME="TransType18" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="24" NAME="TransType19" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="25" NAME="TransType20" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="26" NAME="TransType21" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="27" NAME="TransType22" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="28" NAME="TransType23" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="29" NAME="TransType24" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="30" NAME="TransType25" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="31" NAME="TransType26" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="32" NAME="TransType27" xsi:type="SQLNVARCHAR"/> <COLUMN SOURCE="33" NAME="TransType28" xsi:type="SQLNVARCHAR"/> </ROW></BCPFORMAT>