DSXchange

Remember, it takes only one misplaced/missing quote to trigger it all.

Its not the volume. Because the OPEN statement gets executed before the first record gets inserted. Something else is going on.

Let me ask you this, can you execute a stored procedure from the OPEN command fine ???
If yes then just create a small stored procedure that truncates that table. Three or four lines of code for the stored procedure. Thats it. Atleast you dont have to worry about when it will/will not work and why.

The truncate ghost is messing with you.
Jokes apart, try removing the trailing semicolon. See what happens. I wouldnt be surprised if it works.

See if this posthelps.

Copy paste the entire error message.

First of all you need to get your terminology right.
Job control in subroutine--> tells us that you want to run that same job in its subroutine. You can use DSRunJob() function in JobControl. But not in the same job's properties

Ok the input file looks really suspicious. Your quote character surrounds the delimiter and not the values. I was able to reproduce your error at my end. Its due to the same. Your data is messed up and thats why your getting errors. Build a server job and use a server sequential file stage to read t...

I doubt it. As Whale requested. Can we get a well formatted sample data. Enclose it in 'Code' I just created a file with a pipe as delimiter. Its working fine.

Can you assure that atleast one column will never be a *. The more you can assure the better. If you can assure that then you can load your file to a temp table in your database and write a sql query to get this done. The sql query wont be pretty though. But you shouldnt care, your requirement isnt ...

Ok i am confused. You want to code the DSJobRun in the jobcontrol or the before/after subroutine section. If the later, you cannot run the same job in its before/after subroutine. It will crash and burn.

You sure there is no leading or trailing space. Just increase the size from 10 to maybe 12 and then see if it screams.

i tried using DecimalToString but i could not get the syntax correct. You are on server platform and maybe thats why the DecimalToString function doesnt work. Its just available in px. Server is lineant in data type conversions and doesnt fuss about it. PX on the other hand needs explicit conversio...

Do an exact search on 'Input buffer overrun at field'. This usually means that the data does not match its input schema.

I read that before. You did not answer my question, what is the length that you specified for char? if its 10 then try using varchar.