FTP -> JDPC

[Former Member]

I have an outbound FTP adapter with mapping going to a JDBC adapter. I would like to create a field in the database that contains the directory name i pulled from the FTP server. Is there a way I can map that? The directory is dynamic.

Thanks

Skip Ford

[Former Member]

Hi Skip,

Which directory is dynamic? The directory of file sender channel? I think you need a fixed directory on the file sender channel...

If the directory you are talking about is an information into the file, it's very simple, just need map the field. Please, provide more details.

regards.

roberti.

[VijayKonam]

Skip,

If you the directory name alredy with you in the message that you are receiving, depending on whether you are calling an SP or SQL statement, create an element in the datatype and map it with the source..

If the directory name is coming as part runtime variables, you have to write a UDF to map them to the target.

VJ.

[Former Member]

yes,its possible,use ASMA and then write a UDF to get the directory name and map that to a field on receiver side

Thanx

Aamir