Hi,

I have a transformation which does the following operations.

1) Reads .mdb file (MS-Access Database file) using Access Input step
2) Writes the data to a table in oracle using Table Output step

And I have a job which executes this transformation.

One of tables of .mdb file has a column having datatype as DATE. When I executed the job on a Unix system kettle is giving the following error

"Unable to read row from Access file
Policy Date String: couldn't convert string [Sun Mar 30 00:00:00 IST 2008] to a date using format [yyyy/MM/dd HH:mm:ss.SSS]
Unparseable date: "Sun Mar 30 00:00:00 IST 2008" "

But if I execute this job on a windows system,i am able to execute it without any errors and I also tried by replacing output step with "Execute SQL script" step. In Execute SQL script step I wrote a database insert statement and I try to convert date field using to_date() function. But I am not able pass the second argument of to_date correctly for this type of date format "Sun Mar 30 00:00:00 IST 2008(for example)" type of timestamp.

Please suggest a solution.

Thanks,
Shiva Shankar.