Hi all,

i am having a problem executing my dts though my asp page. this is my 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 "", "sa", "lemmer", DTSSQLStgFlag_Default, "", "", "", "Replenish"
    objDTSPackage.Execute



    For each objDTSStep in objDTSPackage.Steps
        If objDTSStep.ExecutionResult = DTSStepExecResult_Failure Then
            strResult = strResult & objDTSStep.Name & " -- " & objDTSStep.ExecutionResult & "<br>"
            response.Write strResult
            'response.End

            blnSucceeded = False
        End If
    Next

i have tried to debug this by writing the string to screen but the string doesnt make any sense to me. this is what is displayed.

DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSActiveScriptTask_1 -- 1
DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSActiveScriptTask_1 -- 1
DTSStep_DTSExecuteSQLTask_3 -- 1
DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSActiveScriptTask_1 -- 1
DTSStep_DTSExecuteSQLTask_3 -- 1
DTSStep_DTSExecuteSQLTask_1 -- 1
DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSActiveScriptTask_1 -- 1
DTSStep_DTSExecuteSQLTask_3 -- 1
DTSStep_DTSExecuteSQLTask_1 -- 1
DTSStep_DTSDataPumpTask_1 -- 1
DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSActiveScriptTask_1 -- 1
DTSStep_DTSExecuteSQLTask_3 -- 1
DTSStep_DTSExecuteSQLTask_1 -- 1
DTSStep_DTSDataPumpTask_1 -- 1
DTSStep_DTSDataPumpTask_2 -- 1
DTSStep_DTSExecuteSQLTask_2 -- 1
DTSStep_DTSActiveScriptTask_1 -- 1
DTSStep_DTSExecuteSQLTask_3 -- 1
DTSStep_DTSExecuteSQLTask_1 -- 1
DTSStep_DTSDataPumpTask_1 -- 1
DTSStep_DTSDataPumpTask_2 -- 1
DTSStep_DTSExecuteSQLTask_4 -- 1


 the dts has not fired correctly

i have logged the dts but nothing at all appears in the log what so ever.

i am a novice asp programmer

PLEASE HELP
P.S. the dts works perfectly when run through enterprise manager.
and i am using sql 2000

Here's a link that may be able to help you which discusses how to execute a DTS package from ASP:

http://www.sqldts.com/207.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp