I'm trying to run a DTS package through an ASP page but having trouble getting the package to run. Here is the type of connection I'm using to run the package. I can run
the package in Enterprise manager fine but cannot execute it through the web. I created the DTS package with the SA account on the server using SQL authentication. I'm using UNC linking for all the links in the DTS package as well. I still believe that it's a security problem between the webserver and sql server. I'm not sure if I need to edit hte permissions on the IUSR_Webserver account or need to setup the package using windows NT authentication and using a trusted connection in the package. But I'm not too sure on how to set that up.
Here is the error that I'm getting
Create Table SCLevels_summary Step failed.
Copy Data from SCLevels_summary to SCLevels_summary Step failed.
and below is the code I'm using to run the package. Any help would be greatly appreciated.
Dim objPkg, strError, iCount
'Create and Execute the package
Set objPkg = Server.CreateObject("DTS.Package")
objPkg.LoadFromSQLServer "SQLServer", "username", "password", _
'Check For Errors
For iCount = 1 To objPkg.Steps.Count
If objPkg.Steps(iCount).ExecutionResult = DTSStepExecResult_Failure Then
strError = strError + objPkg.Steps(iCount).Name + " failed. " + chr(13)
If strError = "" Then
Set objPkg = Nothing