SQL SERVER BULK ENTRY QUERY

CREATE TABLE [dbo].[TRANSPORTSERIALTRACKING](
[PREFIX] [nvarchar](10) NOT NULL,
[SERIALNUMBER] [nvarchar](30) NOT NULL,
[DENOMID] [int] NOT NULL,
[CURRENCYCODE] [nvarchar](30) NOT NULL,
[DENOMINATION] [nvarchar](30) NOT NULL,
[SERIES] [nvarchar](30) NOT NULL,
[NUMERICSERIALNUMBER] [bigint] NULL,
[SUFFIX] [nvarchar](10) NULL,
[LASTINCASHCENTERID] [int] NOT NULL,
[DATEFIRSTIN] [date] NULL,
[DATEFIRSTOUT] [date] NULL,
[COUNTRETURNS] [int] NOT NULL,
[DATELASTIN] [date] NULL,
[DATEDESTROYED] [date] NULL,
[SORTINGDATEINSEQUENCE] [nvarchar](2000) NULL,
[SORTINGSITEINSEQUENCE] [nvarchar](2000) NULL,
[SORTINGQUALITYINSEQUENCE] [nvarchar](2000) NULL,
[SORTINGMACHINEINSEQUENCE] [nvarchar](2000) NULL,
[TRANSPORTFILEIDINSEQUENCE] [nvarchar](2000) NULL,
[HEADERCARDINSEQUENCE] [nvarchar](2000) NULL,
[TRANSACTIONIDINSEQUENCE] [nvarchar](2000) NULL,
[EMISSION] [nvarchar](60) NULL,
[REPORTINGGROUPTYPE] [int] NULL,
[NONSEQUENTIALREFERENCE] [nvarchar](255) NULL,
[DONEINDICATOR] [int] NOT NULL,
CONSTRAINT [PK_BPSSERIALTRACKING] PRIMARY KEY CLUSTERED
(
[PREFIX] ASC,
[SERIALNUMBER] ASC,
[DENOMID] ASC,
[CURRENCYCODE] ASC,
[DENOMINATION] ASC,
[SERIES] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO