Hi Experts,
Can anybody help me in designing the following scenario.
I have a requirement where in around 1500 PDF files with a file size of 40-50KB are stored in one of the server. we have to pickup these files one by one or all ( I dont know how) read the file name which contains some logic e.g employee number. read this number & insert into SQL table which is already having emplyee no. as a key.Insert this entire PDF file in one of the field of this table against that emplyee no.
Can anybody tell me how to configure this scenario step by step. ?
Secondly the normal FILE FTP adapter will do or do we have to use any special Adapter which can understand PDF format Like INformatica etc.
pl. help me.
Regards,
Umesh