Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickStan
Starting Member
36 Posts |
 Posted - 2009-09-03 : 07:26:00
|
| Does anyone know how to convert word to pdf docs with a dts/stored proc in SQL server 2000?I have been searching for this on the web but have not found anything substantial yet.Surely it can be done. Anyone know how?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-03 : 09:10:59
|
| You can download free PDF printer drivers like PDFCreator:http://sourceforge.net/projects/pdfcreator/As to why you'd want to do this in SQL Server, I can't answer, except that it's certainly not the best way to do it. |
 |
|
|
NickStan
Starting Member
36 Posts |
Posted - 2009-09-03 : 09:42:47
|
| Thanks for the link.I need to have a programatic way of looping around all files in a directory and converting them to PDF.Is there another way to do this (schedule more specifically) instead of SQL server?Can I call PDF Creator from the command line?Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-03 : 17:11:10
|
| I'm not 100% sure about the PDFCreator command line, but it should be fairly easy to use WScript host to open Word documents and print them. There's more info here:[url]http://tinyurl.com/c3p7ge[/url]The trick is specifying the file name for PDFCreator, I'm not sure how that would be scripted.There are other utilities out there that convert Word to PDF, i.e.:http://www.softpedia.com/get/Office-tools/PDF/MS-Word-to-PDF-Batch-Convert-Multiple-Documents-Software.shtmlIt just depends on how much you want to pay. |
|
|
|
|
|
|
Convert Word to PDF in SQL 2000