How to convert the pdf file to blob type ?

Question

How to convert the pdf file to blob type ?

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

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

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

You can use the Import Column task to import the PDF files into the database.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Charmer SSChampion Points: 14903 More actions · Answer 2

Koen Verbeeck (12/18/2012)
You can use the Import Column task to import the PDF files into the database.

Yes Koen, I am using the import column component....but the task gets failed when a file is unavailble in the directory if it is specified in the table. How to avoid such cases?

A file name can be specified in a table where it may or may not be availble in the directory...So i need to skip if the file is not available and move to the next file....

Thanks,
Charmer

Charmer SSChampion Points: 14903 More actions · Answer 3

Koen, FYI

"INSERT INTO [dbo].[Doc_Stage](DocName,DocPath,DocType) VALUES ('" +REPLACE(RIGHT(@[User::FilePath],FINDSTRING(Reverse(@[User::FilePath] ) ,"\\", 1)-1),RIGHT(@[User::FilePath],4),"")+ "','" + @[User::FilePath] + "','" + RIGHT( @[User::FilePath] ,FINDSTRING( REVERSE(@[User::FilePath] ),".",1)-1)+ "');"

I googled and found the above method of inserting the document name. I use this statement to insert the file name dynamically using a for loop containser and execute SQL task.....but this statement is not validated by the expression of execute sql task....could you help me please...?

Thanks,
Charmer

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

Charmer (12/18/2012)
the task gets failed when a file is unavailble in the directory if it is specified in the table. How to avoid such cases?

Two options:

(1) Do a file existence check for each file, using xp_fileexist, a DOS command, a VB script, Powershell or however else you like to do it.

(2) Import the file list into a staging table and join that to your table of files so that you get a list that only includes files that exist.

John

peterwalll SSC Journeyman Points: 82 More actions · Answer 5

Hi, Charmer.

I have seldom tried to convert into a blob file into a table. I wonder have you worked it out? Do I need another 3rd party manual toolkit? When it comes to PDF converting process[/url]I have another question, I wonder have you ever tried to convert pdf to other image files[/url] before? As for myself, I am testing the related PDF to PNG converting , PDF to BMP converting , and PDF to JPG converting programs these days. Do you have experience about it? Any suggestion will be appreciated. Thanks in advance.

Best regards,

Pan

aliaanderson27 Grasshopper Points: 17 More actions · Answer 6

Hope http://pdf-to-jpg-convert.en.softonic.com will helps you