BULK INSERT dbo.DEA_Availability from 'C:SQLPOWERDOCCSVDEA_Availability.csv'
with (
FIRSTROW=2,
FIELDTERMINATOR=',',
ROWTERMINATOR='rn',
ERRORFILE = 'C:SQLPOWERDOCCSVDEA_Availability_ERROR.log',
DATAFILETYPE='char',
keepnulls
)

CREATE TABLE [dbo].[DEA_AVAILABILITY](
    [Server_Name] [varchar](max) NULL,
    [Database_Name] [varchar](max) NULL,
    [Priority] [varchar](max) NULL,
    [Description] [varchar](max) NULL,
    [Details] [varchar](max) NULL,
    [URL] [varchar](max) NULL,
    [IMPORT_DATE] [datetime2](7) NULL
) ON [PRIMARY]
GO