"Mint" <mintsoul@sina.com> wrote in message
news:1168614831.211901.119240@l53g2000cwa.googlegroups.com:

> 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!