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 - 2002-02-18 : 09:31:29
|
| Jeremy writes "If this is an inappropriate question for this site, I appologize.I am currently running SQL Server 2000 (Development Version) on Windows 2000 Professional machine.I have created a DTS package to import text files from a server into the db. After this step, I would like to generate a Power Point Pres. based on info in the db. I figured the best way to do this was to create an ActiveX Script using a PP App object. I dowloaded and modified some VB Code from MS's site and modified it to run in VBScript. When I execute the package, the package executes sucessfully. By making the application visible, I can see that the Script does open PP and creates a New Pres. All code after I open the Pres. does not execute. My question is: Is this the best way to accomplish this task? Because of limited access to the Server, I do not want to create a DLL that needs to be registered on the server. On a monthly basis, we manually run over 100 PP Pres. based on info in the db, and it would be very beneficial to create these Pres. from SQL when I execute the import package.Any suggestions or resources would be greatly appreciated. I can provide my ActiveX Code if required." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-18 : 10:31:11
|
| If you can provide your code, that would be a big help.It may simply be that running that particular bit of code in DTS doesn't work, but moving it into a Powerpoint macro or external VBS file could very well work fine. I think this is better too because you have the option of NOT automatically creating the Powerpoint documents, especially if there is a last-minute change; you wouldn't want to have to re-import all the data.See if moving the code out of DTS works, and if it doesn't, try posting your code here. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-18 : 15:47:04
|
| A totally different track to consider is having your PowerPoint presentation read the data it needs out of an XML file. Then you could just execute a SELECT ... FOR XML off of the database (since you're using SQL 2000) and store that in a file. At least, that works in theory. Haven't tried it in practice.------------------------GENERAL-ly speaking... |
|
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-02-18 : 19:56:10
|
| Thanks guys. The brick hit me in the head this morning and I figured, why not do it in Power Point instead and call a procedure to execute the package from Power Point. Looks both of you think this is probably the way to go as well. Thanks for the help.Jeremy |
|
|
|
|
|
|
|
|
DTS ActiveX Script