• I answered my own questions. You need to use:

    $bulkCopy.ColumnMappings.Add("SourceCol", "DestCol")

    to define the mapping between columns.