Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Varbinary(max) Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 2:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, August 24, 2014 11:15 PM
Points: 463, Visits: 604
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.?

Post #1585782
Posted Wednesday, June 25, 2014 4:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
Take a look at the Export Column transformation in SSIS.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1585808
Posted Wednesday, June 25, 2014 4:35 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, August 24, 2014 11:15 PM
Points: 463, Visits: 604
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,
Post #1585814
Posted Wednesday, June 25, 2014 5:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
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).




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1585830
Posted Wednesday, June 25, 2014 6:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 7,102, Visits: 6,933
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.

Post #1585854
Posted Wednesday, June 25, 2014 6:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, August 24, 2014 11:15 PM
Points: 463, Visits: 604
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
Post #1585862
Posted Wednesday, June 25, 2014 7:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1585895
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse