Import data from PDF to SQL Server 2008 Either by T-SQl or By SSIS

• Eshika

  SSCrazy

  Points: 2046

  More actions

  September 13, 2010 at 5:31 pm

  #97585

  Hi,

  I have a task of loading the data from PF document which has a table structure in it. The table starts at 25 line.

  Would there be any way to load the table in PDF file into the table- SQL Server 2008.

  Your help is a ton. Please suggest.

  Swetha K

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  September 13, 2010 at 9:39 pm

  #1220422

  I'm not sure there's an easy way to do this. You'd have to parse out the PDF document.

  Can you cut/paste the data into Excel and import that?

  This seems to make it seem simple: http://josef-richberg.squarespace.com/journal/2010/1/6/simple-series-ssis-import-column.html

• emily-1119612

  SSCarpal Tunnel

  Points: 4166

  More actions

  September 14, 2010 at 11:02 am

  #1220845

  You have to pre-process the file outside of SQL Server. Search for 'convert pdf csv' and there may be some options. Once you have a csv file all the normal ways of importing into SQL Server will be available.

• Eshika

  SSCrazy

  Points: 2046

  More actions

  September 14, 2010 at 2:55 pm

  #1221010

  I am given a task of automating the PDF data to a table ...... Looking out for possibilities/solution.

  Thank you for the response.

  Please let me know if you come across any solution to do this..

  Thank you.

• keddula

  SSC Veteran

  Points: 243

  More actions

  April 28, 2018 at 12:54 am

  #1988548

  Eshika - Tuesday, September 14, 2010 2:55 PM

  I am given a task of automating the PDF data to a table ...... Looking out for possibilities/solution.Thank you for the response.Please let me know if you come across any solution to do this..Thank you.

  Hi,
  I am looking for the same kind of automation. Can you pls share me the inputs.
  Thanks..