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 |
|
jlk4180
Starting Member
2 Posts |
 Posted - 2007-03-07 : 14:08:31
|
| I have setup a DTS Package using ActiveX to update some information via the SQL DB.When i execute the DTS Package manually by right clicking on it and clicking on Execute Package, it works fine everytime.When I try to schedule the package to run twice a day automatically, when the package starts, it executes once, however the status still shows executing and the next run time is listed as unknown. It seems to hang up and never finish. I do have the Step to quit after success and it still seems not to quit.Any suggestions. This is the first DTS package I have ever used.Thanks for any help |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jlk4180
Starting Member
2 Posts |
Posted - 2007-03-07 : 14:26:23
|
| Basically I have an ASP page that needs to be ran twice a day.Here is the DTS Package ActiveX script I am using:Function Main()Dim oXMLHttp Dim sURL timex = FormatDateTime(Now(),vbTimeDate)on error resume next Set oXMLHttp = CreateObject("MSXML2.XMLHTTP.3.0") sURL = "http://www.yourdomain.com/stocks/convertPending.asp?timex="&timexoXMLHttp.open "GET", sURL, false oXMLHttp.send() if oXMLHttp.status = 200 Then ' Retrieve enter HTML response MsgBox oXMLHttp.ResponseText else ' Failed end if Set oXMLHttp = nothing Main = DTSTaskExecResult_SuccessEnd FunctionBasically the convertPending.asp page is on another server. This page runs another query based on the time provided by the above script that pulls a stock quote from an stock portal.Do i need to put this asp page on the same server the SQL is on?I use two servers...one for websites and another server just for SQL storage for those websites. |
 |
|
|
|
|
|
Scheduling a DTS Package