begin transaction
exec('insert into ZyTax.dbo.ttable(
                             report_state, report_year....
Select                       ztadds,  ztyear ...
from AS400SRV_MSDASQL.VGSYS400.' + @AliasLibrary + '.' + @SourceFile) 
COMMIT TRANSACTION
if @@error <> 0
begin
		set @RetValue = 'Error: upload to ZyTax failed'
		set @InsertOK = 0  -- false 
end

if @InsertOK = 1
if @UpdateOK = 1
if @SourceMember = 'CO55PC'
exec('Update VGITFRLIB.F551202 a set rczflg = 2 where exists (select 1 from ' + @AliasLibrary + '.' + @SourceFile + ' b 
      where a.vcfyr  = b.ztyear and
            a.vcpn   = b.zt#mt  and
            a.rcdoca = b.zt#ds2 and
            a.vcpex1 = b.ztprd1 and
            b.ztscht = "DISB")') at AS400SRV_MSDASQL
if @@error <> 0
begin
		set @RetValue = 'Update processing flag failed for member ' + @SourceMember + ' transaction type DISB'
		set @UpdateOK = 0  -- false 
end