• I think the main difference between "BCP/BULK INSERT" and TVPs is the context to use it.

    Since BCP requires special privileges it's not a feature for front-end applications. TVPs can be used by usual import processes or even GUIs which create larger counts of objects.

    Flo