DSXchange

Was wondering if that was the case... multiple record formats (in and of themselves) do not a complex flat file make.

pterm case noinvert

Me neither, but a quick search shows it is a three part video series on YouTube so guessing the answer is 'no'.

Out of curiousity, what O/S are you running?

I'm thinking you could have the load job split off another link to a semaphore file and only write to it when the code is found. Doesn't really matter what you write to it as you could just check to see if it is non-empty after the job completes. Not empty = backup the source file and that would be ...

If you do get some answers, please come back and update your post. This will help future searchers who come here with similar questions.

Those sound to me like questions for either Salesforce directly or your official support provider.

Your problem = your post, linked back to the other poster's issue. Only thing was I couldn't find a post you'd started in years so guessed on the particulars. Feel free to edit the post to adjust the version, etc. if needed. Now, as to the problem... Consistent? Intermittent? Used to work and then s...

Which database? I have a guess but I'd rather not.

kumarjit wrote:still those new lines are being shown.

Which means you have yet to solve the problem.

Right. Formatting is for peoples, not processes.

sangi1981 wrote:I am not able to see all of your post because I haven't a premium account... How can I obtain it?

On the Home page, in the upper left-hand Navigation section, click on Member Benefits.

I read the first row with the column headers as data and used that to check the names were in the proper order. I'm not aware of any UNIX commands for counting records like that, assuming you mean an actual xls or xlsx file - I always worked with exported csv versions. You may be able to leverage Ex...

Turn off the formatted output option you have turned on right now.

...usually sometimes yes.