Loading image into database table ssis
Hi.. I have couple of images stored in a file.How can i load into a table where i have a column with dtaatype image. Is this possible? Please help me on this.
June 15th, 2011 4:43pm

H i..Chandra, when i used openrowset and inserted image into database I used this statement UPDATE images SET content = (SELECT * FROM OPENROWSET(BULK N'C:\drive\image_1.jpg', SINGLE_BLOB) AS ORS) WHERE imageID = 'F643B' the column updated very long character more than 600 length what does this mean? Am i doing wring any where?
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2011 8:15am

Can some one please help me on this.
June 16th, 2011 1:33pm

how to load a image into a database table?? please help me
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 9:00am

I did that once using Import Column, very easy and found a walk through for you: http://netindonesia.net/blogs/kasim.wirama/archive/2007/09/16/Importing-Image-into-SQL-Server-with-SSIS.aspx In my experience the package was timing out sometimes, it turned out to be an AntiVirus, you may want to disable scanning of that directory.Arthur My Blog
June 17th, 2011 9:26am

What if you run the same query in SSMS?Daniel Cai | http://danielcai.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 9:59am

Hi...when i tried this process it worked but in the column it stored a very long character. is that how it works? I dont have a front end to look at the display. Please confirm.
June 17th, 2011 10:24am

HI..Cai Even if run in SSMS or through BIDS its working same. It is storing a very very long charachter.Is that how it works? Please confirm.
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 10:47am

Yes, you are storing the binary image in that column, it is sure going to be long.Daniel Cai | http://danielcai.blogspot.com
June 17th, 2011 10:51am

Thanks Cai
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 10:53am

Cai.. The length of that binary image is 62,150. Is that right?
June 17th, 2011 11:00am

That really depends on the size of the image file. I see nothing wrong with an image file of 62,150 bytes. Daniel Cai | http://danielcai.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 11:01am

alright cai. Than you very much
June 17th, 2011 11:19am

You are welcome... Cheers,Daniel Cai | http://danielcai.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 11:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics