varbinary data

Question

Hello

I have a bunch of images I need to put in the database and then retrieve later using a Script task in SSIS.
Is the only way to save the images to the database in the application? Is there anyway to do it using t-sql?

Thank you

---

AE, MCTS

Answer 1

hi,
you can use the SSIS to dump the images into database itself. let me know your problem.

thanks-

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 2

Which task would I use? These images are jpeg saved on one of our network drives.

---

AE, MCTS

Answer 3

hi,
I never tried this case in SSIS. let me do some work around it. mean while please check the following link to create Stored procedure for it.  http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm

Thanks- 

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 4

Hello Peso

What if I have 50 images?

Thank you

---

AE, MCTS

Answer 5

FOR EACH container?? Are you talking about SSIS?

---

AE, MCTS

Answer 6

I started testing on one file using SSMS, and I got this error.

A correlation name must be specified for the bulk rowset in the from clause.

Here is the code I'm using

CREATE TABLE myTable(id int identity(1,1),
					Document varbinary(max))

 INSERT INTO myTable(Document)
 SELECT * FROM OPENROWSET(BULK 'C:\Image1.jpg', SINGLE_BLOB) 

---

AE, MCTS

Answer 7

I added as after the bracket, that did it, but now I have this error

Cannot bulk load. The file "C:\Image1.jpg" does not exist.

---

AE, MCTS

Answer 8

Haha, just realized that and tested a txt file on the server and it worked fine.
I'll try with the image

THANK YOU

---

AE, MCTS

Answer 9

Just one more thing to add, here is what I used and it worked

CREATE TABLE myTable(id int identity(1,1),
		Document varbinary(max))

 INSERT INTO myTable(Document)
 SELECT * FROM OPENROWSET(BULK 'C:\Image1.jpg', SINGLE_BLOB) as ImageLoad

---

AE, MCTS