Batch insert images into SQL Server with conditions

Question

Viewing 9 posts - 1 through 8 (of 8 total)

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

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

Can you give some example of what you are trying to do? Table ddl would be nice.

SSIS has the import column transformation, it may be worth checking that one out.

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

yegane.yousef Valued Member Points: 60 More actions · Answer 2

Hi!

Thanks. This is my case.

I want to import some images base on the PK_ID.

Thanks again.

yegane.yousef Valued Member Points: 60 More actions · Answer 3

Valued Member

Points: 60

June 14, 2014 at 4:32 am

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Did you try the SSIS import column transformation I mentioned earlier?

Importing Files Using SSIS[/url]

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

yegane.yousef Valued Member Points: 60 More actions · Answer 5

Well, I didn't actually.

Honestly, I haven't worked with SSIS.

Do you think that would help me? If it does, I would learn it.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 6

It would satisfy your requirement yes.

You would only need to create the full path at which an image is located.

Currently only the last part of the filename is stored in the table.

I see for example 22068.jpg.61018_PICTURE.jpg in the screenshot, where 61018 is a PK stored in the table.

You'd need the first part as well.

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

On the other hand, since you have not used SSIS yet, a small C# app might be easier:

Uploading Images to a Database ( C# ) – Part I[/url]

You would need to loop over all of the files in the folder, extract the PK and match it against the table.

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

louisscott SSC Enthusiast Points: 158 More actions · Answer 8

I would like to say thanks Koen Verbeeck who share this link here. It is very helpful for me while insert images into SQL server.