Error to use a Transformation in a Package

When I use a data transformation in a package don't work properly.
But when I use the same transformation stand alone, work OK.

The transformacion insert a File to CLOB Field of Oracle Database Table

Whem I use the Transformacion in the Package send the error :

Information 09/04/2012 09:30:45 p.m. Starting Transformation...
Information 09/04/2012 09:30:45 p.m. Map Name: Subir CLOB
Information 09/04/2012 09:30:45 p.m. Author:
Information 09/04/2012 09:30:45 p.m. Version:
Information 09/04/2012 09:30:45 p.m. Description:
Information 09/04/2012 09:30:45 p.m. Preparing Writers...
Information 09/04/2012 09:30:45 p.m. Writer: {}, Writer { } Is Ready
Information 09/04/2012 09:30:45 p.m. All Writers are Ready
Information 09/04/2012 09:30:45 p.m. Processing Data...
Information 09/04/2012 09:30:45 p.m. Reader:{} Path: \temp\etl test\Recep FTP\
Information 09/04/2012 09:30:45 p.m. Reader:{} Mask: *.*
Information 09/04/2012 09:30:45 p.m. Reader:{} Found: 110 File(s) to read
Information 09/04/2012 09:30:45 p.m. Reader:{} Reading first 1 files
Error 09/04/2012 09:30:45 p.m. 1 Writer: {}, Value '"nombre","fecha","nombre","cant","ivta_siva"
"CAJA CRISTAL PECHE MIGNON","2011-02-10 10:59:34.827","OPERADORA BAJO DE LA TINTORERA, S.A. DE ","4","246207"

---

Finaly Write at the end.
"CAJA CRISTAL EARL GREY SUPERIOR","2012-04-03 17:58:43.707","ADMINISTRADORA DE RESTAURANTES FUSION- A","1","66249"
' is too long for field ARCHIVO

The file has 700 Kb.

When I use transformation Stand Alone, log is:

Information 09/04/2012 09:47:35 p.m. Starting Transformation...
Information 09/04/2012 09:47:35 p.m. Map Name: Subir CLOB
Information 09/04/2012 09:47:35 p.m. Author:
Information 09/04/2012 09:47:35 p.m. Version:
Information 09/04/2012 09:47:35 p.m. Description:
Information 09/04/2012 09:47:35 p.m. Preparing Writers...
Information 09/04/2012 09:47:35 p.m. Writer: {}, Target table has blobs using array insert, BatchSize=1
Information 09/04/2012 09:47:35 p.m. Writer: {}, Writer { } Is Ready
Information 09/04/2012 09:47:35 p.m. All Writers are Ready
Information 09/04/2012 09:47:35 p.m. Processing Data...
Information 09/04/2012 09:47:35 p.m. Reader:{} Path: \temp\etl test\Recep FTP\
Information 09/04/2012 09:47:35 p.m. Reader:{} Mask: *.*
Information 09/04/2012 09:47:35 p.m. Reader:{} Found: 110 File(s) to read
Information 09/04/2012 09:47:35 p.m. Reader:{} Reading first 1 files
Information 09/04/2012 09:47:35 p.m. Reader:{} Read: 1 Records/Lines/Messages (in total)
Information 09/04/2012 09:47:35 p.m. Reader:{} Records/Lines/Messages per second: 7.04
Information 09/04/2012 09:47:35 p.m. Reader:{} Rejected: 0 Record(s)
Information 09/04/2012 09:47:35 p.m. Reader:{} Time Taken: 00:00:00
Information 09/04/2012 09:47:35 p.m. Writer: {}, Inserted : 1 Record(s)
Information 09/04/2012 09:47:35 p.m. Writer: {}, Updated : 0 Record(s)
Information 09/04/2012 09:47:35 p.m. Writer: {}, Deleted : 0 Record(s)
Information 09/04/2012 09:47:35 p.m. Writer: {}, Errors : 0
Information 09/04/2012 09:47:35 p.m. Transformation Completed


Hopefully you can Helpme.

We will help you of course.

Before running the transformation from the package have you saved it?

Mike

Yes, it has been saved.

I even tried to exit of the program and then to start again but I have the same result.

Thanks
Jorge

In thins case can you provide us with table creation script and backup of the repository please

Mike

Tested everything myself and it is working fine

Using oracle 11g.

Once data is loaded we always recommend exporting the files back just to make sure that everything is fine.
I would also recommend using blobs instead of clobs.
You may want to load different kind of files later.

Mike

We have reproduced the problem and looking at what can be done about it

Mike