depending on how the data looks, if its guaranteed to the exclusion is guaranteed to be the fisrt word in the string and is separate you can use substring with...

sent you a PM with a script i created to do a similar task

you could use bulk insert instead of BCP

i will send you an example via private message if i can

is the source and destination on the same server or could you create a linked server if not? 

then insert from select ?

or you could try this...

create table #temp (id varchar(50),subid varchar(10),pcs varchar(10))

    insert into #temp select 'abc', 'w 10',NULL
    insert into #temp select 'abc', 'e 20',NULL
    insert into #temp select 'abc', 'g 70',NULL
    insert...

these are only suggested indexes they may not make any difference at all, are you having issues with performance?

what makes you think there are missing indexes?

permissions (security principles) are given at 3 levels, Windows server / AD, SQL server and DB

is you AD account an administrator

if  you are wanting to return the identity of the insert perhaps to use as a foreign key in another insert 

create table x1 (id int identity(1,1),col2 varchar(100))

sounds to me like you need a bespoke app to complete your task. alternatively you could create a stored procedure and allow your uses to execute this via SSMS? 

SELECT * FROM TABLE_NAME
ORDER BY 1,2

SELECT * FROM TABLE_NAME
ORDER BY FISRTCOLUMN, SECONDCOLUMN

create table Q (col varchar(20))

insert into q select 'ab_re_uk_u_20101001' union all
select 'ax_by_us_19991001' union all
select 'abc_20181002'

select *,substring(col,0,patindex('%[0-9]%',col)-1) from q

you could try 
where replace (column_name,',','')='Acme Products Inc'

or look to have the DB changed to include a csoundex column or even

where soundex (column_name) =soundex('Acme Products Inc')

Use dynamic SQL to build and execute your code and run through a while loop 

        declare @insert varchar(1000),
                @row as int,
                @max as int,