| Author |
Topic |
|
awal
Starting Member
5 Posts |
 Posted - 2003-01-13 : 11:48:55
|
| Is there any way to call upon a web page from a dts package? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-13 : 11:57:17
|
| I *have* done this in the past, but you need to be VERY careful in how you go about using it. Can you provide more detail on what the web page is, and what it does when called?The method I used utilized the MSXML COM library and the XMLHTTP object. If you search for them on MSDN you'll find code examples that can request a web page (optionally passing form parameters using GET or POST) and get the response back as a string. You can then parse that string to get the page contents.This is best used where you can request the web page up front and get all of the data, then close the page, then move on with the rest of your DTS package. It is NOT a good method for automatically filling out a web page with data from a DTS job, or anything that would require to web connection to be open for any length of time. |
 |
|
|
awal
Starting Member
5 Posts |
Posted - 2003-01-13 : 12:14:01
|
| I have an asp page that creates a Crystal Report Object and exports the results to a file. I am trying to run this at various times. The only solution I could come up with was to somehow get this to run from a dts package. I am open to ideas, but I would rather not move the code from the asp page, since i didn't write it and it is very very messy. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-13 : 12:26:50
|
I'm gonna back up a step or two. What does this Crystal Reports report, well, report on?  What information does it provide? How does it get that data from SQL Server?I'm not seeing the need for DTS at all here. You can create a regular SQL Server job and write code as an ActiveX step to do the same thing. Unless you're taking data from the Crystal Report and using it as a source for a DTS job...in which case, where is that data being imported to? Or is it simply to copy the Crystal Report and distribute it to people?I'm thinking there's probably another way to do what you want and you can avoid the Crystal Reports step altogether, but I need to know WHAT the process is, not just how it works. |
|
|
|
awal
Starting Member
5 Posts |
Posted - 2003-01-13 : 12:39:06
|
| The Crystal Reports Object that sits on the Web Server actually pulls data from the sql server and then creates a .rpt file that sits on the webserver. I could probably move the code from the webserver to the sql server, but the object would need to be registered on the sql server and unfournatly our dba is not allowing it.I was actually hoping to write an activeX script that would accomplish this. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-13 : 12:56:51
|
| OK, but what do you need to do with the Crystal Report? |
|
|
|
awal
Starting Member
5 Posts |
Posted - 2003-01-13 : 13:05:15
|
| I need to create the crystal report file (ie myreport.rpt). The only way to do this is through the crystal report object, which is already on the webserver. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-13 : 13:14:05
|
| No no no. WHY do you need to create the Crystal Report? The fact that it's on a web server doesn't mean anything. It just sits there unless someone reads it. Are you sending the report to someone else? Does it update a web page that other people read? You're not explaining the reason behind why you need the Crystal Report, and yes, I DO need to know because if it's not necessary to run the Crystal Report then you don't need to open the web page.I'm not asking these questions just to be nosey. I can't come up with an effective answer unless I understand what's going on and why it's going on. |
|
|
|
awal
Starting Member
5 Posts |
Posted - 2003-01-13 : 13:27:57
|
| figured it out....thanks for the help |
|
|
|
|
Call a webpage