PDF Documents as a Data Source using SSIS

You need to import some tabular data into your database via SSIS but your customer can only deliver it in PDF format.

The Nitro PDF tool isolates tabular content in a PDF and converts it to Excel format.

http://www.nitropdf.com/sem/2012/convert-pdf-to-excel?gclid=CMrq7LGFkbQCFQRKpgodIlAASQ

It supports command line operation and can therefore be integrated within the SSIS package control flow using the Execute Process task.

http://kb.nitropdf.com/article.aspx?id=10163

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s