Date fields From XML to a sequential file......

[pavans]

Hi
Source: XML FIle
Target :Sequential File
Processing Stage: Transformer.
I have date fields in the below format.
These fields are not getting populated into the sequential file.
The job is runnning fine.
Let me know,
do i need to use any date conversion here.
datatype is date from source and target.

ReqCancelDate="03/05/2008" ReqDeliveryDate="03/20/2008"

[eostic]

If it's that simple a job, check your xpath.... (Description property on the noted columns in the output link of your XMLInput Stage).....

One guess is that the columns simply aren't in the link... (could be that they weren't in the referenced XML instance doc that you used for meta data import).

Also could be that there is a spelling error. hard to tell without seeing it here...but you should have something like a column called ReqDeliveryDate with Description propety of:

/<your higher level element(s)/<immediate higher element>/@ReqDeliveryDate

Make the datatype varchar.

Ernie

[chulett]

Make the datatype varchar.

I would think that this is the key piece of advice here.

[pavans]

If it's that simple a job, check your xpath.... (Description property on the noted columns in the output link of your XMLInput Stage).....

One guess is that the columns simply aren't in the link... (could be that they weren't in the referenced XML instance doc that you used for meta data import).

Also could be that there is a spelling error. hard to tell without seeing it here...but you should have something like a column called ReqDeliveryDate with Description propety of:

/<your higher level element(s)/<immediate higher element>/@ReqDeliveryDate

Make the datatype varchar.

Ernie

It worked..........now.
I have the datatype for the date fields in Transformer as Varchar.

Thanks a lot....