DSXchange

Can't you simply specify that strings are doubled-quoted in the stage and let them be handled automatically? It won't care if they're not there and will remove them when they are.

I guess so, just didn't seem like one of those at first read. Does more so on the second. :wink: In the realm of "enough background information" I would like to see this expanded with specifics of the change needed: You should modify the user profile so it does not generate errors when a p...

I don't think this is 'obviously' anything yet. As to your questions:

1) In a Type 2 load? None.
2) No.

Why is this marked as Resolved? Did you figure out your issue?

Seriously? So not a new line character at all but literally two characters - a slash followed by an N. And if that's the case there's absolutely no need for the Convert() as a simple if-then-else would suffice.

This question has been asked and answered quite a bit here, an exact search for "email body" will answer your question.

You didn't answer my question but if you use -jobstatus then you are on the right track as 1 = Finished OK, 2 = Finished with Warnings, 3 = Aborted, etc.

Which dsjob option are you using in your script: -wait or -jobstatus? You should be using the latter if you want to differentiate between the status values a job can end in.

Could be, especially if there is a lot of "white space" in the file. You'd have to factor in the time to compress and then uncompress the file but certainly worth a shot.

Off you go to your own version of this topic..

Talk to your Admins.

ArndW wrote:I use the term "dummy sort" as well for sort stages that specify "don't sort, already sorted".

That's all I was trying to confirm.

Please detail for us what "dummy Sort stages" mean in your job. As to the Job Monitor, realize that rows/second are over the entire run of the job so anything that starts "late" starts in a deep hole, rate-wise.

Of course, there are other games you can play. You could build and write out a single record much as posted but rather than the pipes separate the three segments with a line feed. You'll write out one record but anything reading it will read three: svLF = CHAR(10) Output = 'Total_Data_Count,' : Col1...

BIuser wrote:Please confirm if this approach is right ?

Is the output what you need it to be? That would go a long way towards saying your approach was fine.