why my asp script failes to process DTS with access database connection?
- From: "Mint" <mintsoul@xxxxxxxx>
- Date: 12 Jan 2007 07:13:51 -0800
i want to run an asp script to run DTS packedge.
i have created the packedge in the sql server. only include a
connection to access database
and a only a sql task (select * from acctbl).
i can run the dts successfully in the sql server.
but i can't run it in the Asp script.
when i change the connection to a sql database. it is successfully.
why it faild?
the asp script is right i think.
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 servername, usrname, pwd,
DTSSQLStgFlag_Default2, "", "",
"", dtsname
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
end if
can anyone help?
thanks!
.
- Follow-Ups:
- Re: why my asp script failes to process DTS with access database connection?
- From: Allan Mitchell
- Re: why my asp script failes to process DTS with access database connection?
- Prev by Date: Re: Subqueries in SQL Server
- Next by Date: how to set the Variables to a value in a asp script?
- Previous by thread: Subqueries in SQL Server
- Next by thread: Re: why my asp script failes to process DTS with access database conne
- Index(es):
Relevant Pages
|
