Post reply

.PDF Image Import

  • October 20, 2011 at 1:13 pm

    #390668

    Hi guys,

    Quick question,

    How i can import .pdf Image into SQL Server through SSIS?

    Thanks in advance.

  • October 20, 2011 at 1:56 pm

    #1397633

    If you are talking from a file very likely. But since you are in 2005 I can't remember if the Import Column task is available in the Data-Flow. If so I would probably use that.

    CEWII

  • October 20, 2011 at 2:23 pm

    #1397650

    Thanks for reply, But how i can use .pdf as a source, which source should i use

    ADO NET Source, Excel Source, Flat File Source, OLE DB Source, Raw File Source or XML Source.

    It is not a one file, One ID Belongs to one file so i think the folder has 30k .pdf files.

  • October 20, 2011 at 2:29 pm

    #1397655

    Because the file will need metadata, it is not a source, you can use any source, the component I mentioned is used in the pipeline between the source and the destination.

    CEWII

  • October 20, 2011 at 2:34 pm

    #1397658

    Here is the problem, I can't select that folder, that have all .pdf files. If you please explain me it would be great. Thank You!

  • October 20, 2011 at 2:54 pm

    #1397667

    You might look at: http://sqlserverpedia.com/blog/sql-server-bloggers/simple-series-ssis-import-column/[/url]

    CEWII

  • October 24, 2011 at 5:08 pm

    #1398931

    rocky_498 (10/20/2011)

    Hi guys,

    Quick question,

    How i can import .pdf Image into SQL Server through SSIS?

    Thanks in advance.

    If you are trying to extract an image from inside the PDF document, then there is no standard component available for this in SSIS. For a third-party solution, check Monarch Pro.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 7 posts - 1 through 6 (of 6 total)

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