Post reply

Blob to PDF

  • April 13, 2015 at 11:41 pm

    #296882

    Hi

    I am using sqlserver 2005. We are managing student document like a semester wise mark sheet and old documents.Currently we are storing jpeg file separately.My table structure is

    Registerno DocumentID Image

    (char) (Char) (Image data type)

    eg ..

    REg1 D1 certificate1

    Reg1 D2 certificate2

    Reg1 D3 Certificate3

    Reg2 D1 Certificate1

    Reg2 D2 Certificate2

    Reg2 D3 Certificate3

    .

    .

    .

    .

    Regn D1 Certificate1

    My requirement is , Output require a PDF format like a (Combine of certificates in student wise).

    Reg1,reg2 Combine all the certificate output should be single pdf file register number wise.Please give me a solution any possibilities directly convert Image to Pdf using sql Query or SSIS.

  • April 14, 2015 at 3:01 am

    #1790697

    Hardly it's possible with pure SQL or SSIS.

    You need some pdf-aware soft, MS Word for example. Create vba macro which will retrieve proper images from DB and place it in a proper document layout and them save document as .pdf (word 2007+).

    Or you may want to create an app using java iText lib, free for non-commercial usage. C# port is also available http://sourceforge.net/projects/itextsharp/ so SQL CLR proc may be created as well.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply