BULK
INSERT #CSV
FROM 'C:UsersMyNameDesktopPlayers.csv'
WITH
(
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = 'n'
)

DECLARE @path NVARCHAR(4000) = 'C:UsersMyNameDesktopPlayers.csv';

BULK
INSERT #CSV
FROM @path
WITH
(
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = 'n'
)