How to read pdf using ssis?

Question

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

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

sankarboggarapu Valued Member Points: 60 More actions · Answer 1

Valued Member

Points: 60

April 26, 2011 at 2:48 am

No, We cannt read PDF data into SSIS.

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 2

"No, We cannt read PDF data into SSIS."

You can convert the PDF file to a textfile and then use SSIS

I don't use SSIS but VB.net. My tip is to create a VB script which

open the PDF file in binary mode and writes the content to a textfile.

That should be possible with SSIS

Of course you must understand how the PDF file is formatted. You may

import the textfile to a staging table and from that table use substring

functions to extract each field.

/Gosta