|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hello,
Sorry to bother you, I was reading the article, that shows how to run the DTS from an ASP. And Actually when I run the page locally it works fine, my DTS runs smoothly. But, when I upload it to the web server it fails. Database has the same username and password, DTS has the same name .. just like in my development computer. But it still fails. .. I included the code below. Is this common ? .. Is there anything in special I need to change or doublecheck ? I appreciate your help. Code:
<%
dim objDTSPackage
dim objDTSStep
dim strResult
dim blnSucceeded
const DTSSQLStgFlag_Default = 0
const DTSStepExecResult_Failure = 1
set objDTSPackage = Server.CreateObject("DTS.Package")
blnSucceeded = true
objDTSPackage.LoadFromSQLServer "(local)", "amucinoariastovar", "password", DTSSQLStgFlag_Default, "", "", "", "AriasTovarCMSEILA"
objDTSPackage.Execute
for each objDTSStep in objDTSPackage.Steps
if objDTSStep.ExecutionResult = DTSStepExecResult_Failure then
strResult = strResult & "Package " & objDTSStep.Name & " failed.<br>"
blnSucceeded = false
else
strResult = strResult & "Package " & objDTSStep.Name & " succeeded.<br>"
end if
next
if blnSucceeded then
Response.Write "<h1>Package Succeeded</h1>"
else
Response.Write "<h1>Package Failed</h1>"
end if
Response.Write strResult
%>
Alejandro Mucino |
|
#2
|
|||
|
|||
|
i have the same problem as well, although it worked with a simple DTS task, it did not work with a more complex db copy that works fine from enterprise manager. any solutions yet???
|
|
#3
|
|||
|
|||
|
make sure to run the web app out of process as a user who has permission to execute the DTS on the database.
|
|
#4
|
|||
|
|||
|
Asp Dts
I have a web page executes a DTS package successfully,
It imports data from Excel into SQL Server. The Exact same page fails when trying to run a DTS package that copies data from one SQL Server table to another. Any help will be appreciated. twilborn |
|
#5
|
|||
|
|||
|
well this is my first post the error is the same for me.. i only change the user name and pasword in connection (OLE DB PROVIDER, ETC).. SQL DTS Designer.. not windows authentication SQL Server Authentication and runs like hell..
Saludos desde mexico... |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Run DTS from ASP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|