Just to be clear Im not looking to add the lines from the csv. Just want to update the existing db from the csv with products that are already in...

Modified Code
DECLARE @CT INT
SET @CT = (SELECT COUNT([pID]) FROM [dbo].[Products])

IF ISNULL(@Ct,0) > 0
BEGIN
  UPDATE a SET pWholesalePrice=src.NZToner, pListPrice=src.Sell,...