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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Executing a DTS package from ASP

Author  Topic  dayanand Starting Member 1 Post Posted - 2004-10-22 : 04:55:21 Dear All, I have created a DTS package and i could execute that package from Visual Basic it is working fine but the same package when i treid to execute from ASP i am getting errors as below, what is the wrong?? Package DTSStep_DTSExecuteSQLTask_1 failed. Package DTSStep_DTSExecuteSQLTask_2 failed. Package DTSStep_DTSDataPumpTask_1 failed. Please anybody can help me why i am unable to execute a DTS package from ASP. below is my ASP 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 "CBJ-S-469", "Daya", "pa55word", DTSSQLStgFlag_Default, "", "", "", "pkgSAGE_NewData_Extr" 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 %> Thanks In advance. Dayanand