• Have you tried the bulk insert without the "with"? 

    BULK INSERT tempdb.dbo.TEMP_PERFMON_OUT

     FROM '<YOUR_FILE_NAME>.txt'