CREATE TABLE [dbo].[EvAlaska]
(
    [EvID] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
    [GeoID] VARCHAR(10) NOT NULL, 
    [Year] smallint NOT NULL, 
    [LocationName] VARCHAR(40) NULL, 
    [ParentLocation] VARCHAR(40) NULL, 
    [Population] int NULL, 
    [PovertyRate] decimal(7,2) NULL, 
    [RenterOccupiedHouseholds] int NULL, 
    [PctRenterOccupied] decimal(4,2) NULL, 
    [MedianGrossRent] int NULL, 
    [MedianHouseholdIncome] int NULL, 
    [MedianPropertyValue] int NULL, 
    [RentBurden] decimal(3,1) NULL, 
    [PctWhite] decimal(4,2) NULL, 
    [PctAfAm] decimal(4,2) NULL, 
    [PctHispanic] decimal(4,2) NULL, 
    PctAmInd decimal(3,1) NULL, 
    PctAsian decimal(3,1) NULL, 
    PctNhPi decimal(3,1) NULL, 
    PctMultiple decimal(3,1) NULL, 
    PctOther decimal(3,1) NULL, 
    [EvictionFilings] int NULL, 
    [Evictions] int NULL, 
    [EvictionRate] decimal(3,1) NULL, 
    [EvictionFilingRate] decimal(3,1) NULL, 
    [LowFlag] bit NULL, 
    [Imputed] bit NULL, 
    [Subbed] bit NULL
)

BULK INSERT EvAlaska
FROM 'C:\tmp\AK.csv'
WITH
(
    FIRSTROW = 2,
    FORMAT = 'CSV', 
    DATAFILETYPE = 'char',
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '0x0a',
    ERRORFILE = 'C:\tmp\AK-err.csv'
    ,TABLOCK
)