A simpler method that worked for us was to:
Import the CSV using either the method you mentioned or through an SSMS Task, but to a new table.
Encrypt the column on the new table so the column data types match between the new and existing tables.
Perform an INSERT INTO ... SELECT FROM ... query to insert from the new table to the existing table.
Drop the new ...