DSXchange

I dont think space in the file name field is valid. Cant you ask your source system to send the file without space in the name?

I believe there is a typo in your output. From what I understand, your output should be: id,sum,diff ------------ l1,69,29 l2,45,45 l3,102,10 If my understanding is correct, I created a small job and tested it. Try and let us know: Assuming your source is a flat file: BEGIN HEADER CharacterSet "...

I'm not sure if there is a way to list the file names that were processed but you can use a 'ls' command with the same file pattern and print it to the log.

We use to define the column as LongVarChar with 999999999 to read and write the CLOB data. And its working fine.

Set you job level NLS to MS1252. It should work.

Why dont you just include a parameter in your main sequence to say what kind of run it is and determine what value to pass to child sequence?

Its @FM

Set the value as user status in Job A and pass it on to Job B in the Sequence.

We do get the same issue as Gregg and as said closing and opening the client will solve this issue. And this is regardless of Designer or Director..

Even the job parameters or ENV variables are used in that way

chulett wrote:Actually, they're not. What you have in sequential files are empty fields rather than nulls. ...

Craig,

You mean to say IsNull will not treat this field as NULL? I believe they do.

Hi, We are trying to create a target xml file. The requirement is NOT to create an empty attribute in the target. I know used the option "Replace empty with NULL" in the xml output stage but this doesnt work for the attributes. Can you please let me know if there is a way to achive this? T...

How have you defined your xPath and what is your repetition element?

Did it work?

We got this error most of the time when there is a special character in the data and the NLS is not defined properly.