Varbinary(max)

Question

Varbinary(max)

Mr. Kapsicum

SSCertifiable

Points: 6128
More actions
June 25, 2014 at 2:56 am

#308490

Hi Guys,
I have a Table "Candidate" which has column "Resume" which is in VARBINARY(MAX).
Now we need to migrate these Columns (i.e. Resume) in DOCX files.
How to do this.?
is BCP going to be useful or something else.?

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

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

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

Take a look at the Export Column transformation in SSIS.

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

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 2

Hi Koen,

Thanks for the Reply.

But Can you please help me with some other Solution, I cannot use SSIS in this Case.

Can BCP help in this case.

Regards,

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Mr. Kapsicum (6/25/2014)
Hi Koen,
Thanks for the Reply.
But Can you please help me with some other Solution, I cannot use SSIS in this Case.
Can BCP help in this case.
Regards,

Well, your question said "... or something else" 😉

Assuming BCP can export to a docx file (maybe if you extract just that one column from the table and dump it directly into the file), it still exports one row at a time (because you can only extract and write to one file at a time).

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

David Burrows SSC Guru Points: 65143 More actions · Answer 4

https://www.simple-talk.com/blogs/2007/07/13/using-bcp-to-export-the-contents-of-max-datatypes-to-a-file/

Far away is close at hand in the images of elsewhere.
Anon.

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 5

Hi Koen,

Can u please suggest any Important Points that needs to taken care of while Working on Varbinary for docx file making.?

or Can Case Study available for this.?

Thanks,

Regards

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

Mr. Kapsicum (6/25/2014)
Hi Koen,
Can u please suggest any Important Points that needs to taken care of while Working on Varbinary for docx file making.?
or Can Case Study available for this.?
Thanks,
Regards

No idea. I use the Export Columns transformation in SSIS 😉

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