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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-28 : 08:15:51
|
| Richard writes "I have about 1000 clients. We update data for them weekly in SQL Server 2000. We want to each time we update their data, create a PDF and write to our web server for them to access it. I have a COM object from a site called DynamicPDF.com that allows me to create a web page that will create the PDF, using Server.CreateObject("DPDF_Gen.Document") to create the object in the ASP page and use VB Script to generate the PDF. However, that solution requires the user to generate his own PDF. I want SQL to do it for him. I can't figure out how to do this. I have been told to use DTS and I have been told to use "command shell". Neither seems to be exactly right, but maybe that is only because I don't know exactly how to do either of them." |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-10-28 : 08:21:58
|
i don't think you want SQL to do it, you just don't want the user to do it on his own.My suggestion: Use the asp method in a loop format so that it creates and saves each pdf to the website... Schedule it to run at night and Viola! The user isn't waiting for it to build.However: We build pdfs on demand All the time, and its plenty fast!  Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
 |
|
|
|
|
|
Creating a PDF file within a Stored Procedure