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
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