Import G-NAF to SQL Server Instance

import-gnaf-sqlserver.sql

use [G-NAF]
-- Clean existing
delete FROM dbo.ADDRESS_ALIAS
TRUNCATE TABLE dbo.ADDRESS_ALIAS
SELECT COUNT(*) FROM dbo.ADDRESS_ALIAS
GO
BULK
INSERT dbo.ADDRESS_ALIAS
FROM 'D:\G-NAF\FEB16_GNAF_PipeSeparatedValue_20160222170142\G-NAF\G-NAF FEBRUARY 2016\Standard\ACT_ADDRESS_ALIAS_psv.psv'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
)
GO
SELECT COUNT(*) FROM dbo.ADDRESS_ALIAS