Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to read data in a pdf file in SSIS RE: How to read data in a pdf file in SSIS

  • August 8, 2012 at 2:55 am

    #1523005

    sql server developer (8/6/2012)

    Thanks for your reply Lowell. I have Adobe Acrobat X V 10.1.0 and don't see the TEXT option when I try to save it. Also, our pdf file is in such a way that it has location block on the upper right hand corner from which i need to get address, city, state, country etc. And some other details in the lower right hand corner which i need to separate out while loading them to SQL Server. I've 7000 files of this kind. Is there a way to do this without having to using c# programming?

    Thanks in advance!

    Is the data stored in the PDF as text? Can it be selected and copied?

    Or is it there as an image?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.