BCP 2000 - Function sequence error

SSIS and Import/Export
5

yes my command and everything is correct in batch job.

I just found more details.

This job run in following scenarios :

1.if my sp contains only select statement with out temp table like

select * from TMP_FLATFILE

  1. my sp contains temp table liek in sp and data in table contains first record and second record as below

--First Record

insert into TMP_FLATFILE values('0000010218')

--Second Record

INSERT INTO TMP_FLATFILE SELECT '10~01~APLEGAL~APLEGAL_HKHKD_LEGALHK-FCY_20150730_114300_INV_FLAT.TXT~16670~49~20150730:114300~~~'
2. my sp contains temp table and data in table contains first record and second record as below and if I removed "AT" from first row value (INV_FLAT.TXT)

--First Record

INSERT INTO TMP_FLATFILE SELECT '10~01~APLEGAL~APLEGAL_HKHKD_LEGALHK-FCY_20150730_114300_INV_FL.TXT~16670~49~20150730:114300~~~'

--Second Record

insert into TMP_FLATFILE values('0000010218')

This job NOT run in following scenarios :

  1. my sp contains temp table liek in sp and data in table contains first record and second record as below

--First Record

INSERT INTO TMP_FLATFILE SELECT '10~01~APLEGAL~APLEGAL_HKHKD_LEGALHK-FCY_20150730_114300_INV_FLAT.TXT~16670~49~20150730:114300~~~'
--Second Record

insert into TMP_FLATFILE values('0000010218')