Bulk insert does not have an option that will allow you to intercept the data on its way into the table and LTRIM/RTRIM it. What you suggested - updating the table after the insert - is perhaps the best course of action.

Bulk insert does not have an option that will allow you to intercept the data on its way into the table and LTRIM/RTRIM it. What you suggested - updating the table after the insert - is perhaps the best course of action.