encryption on columns in table

• vihaan

  Old Hand

  Points: 355

  More actions

  March 1, 2019 at 11:42 am

  #382852

  Hello ,

  I have encryption on one column in a table.
  There is a csv file that needs to get loaded into this table and one column DOB which is in the file needs to get loaded into encrypted column in table.

  We are using SSIS packages to load data into tables, how can load data into encrypted columns.

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  March 1, 2019 at 12:02 pm

  #2023335

  just insert it. SQL Server handles the encrypting of the data before it gets written to the table.