Skip to Content
0
Former Member
Jul 21, 2008 at 05:24 AM

How to Insert the entire PDF File as one of the Field in SQL table ?

44 Views

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