I've written a CF file upload process that uploads Excel file into a SLQ 2K Db using DTS. The original code uses a CFExecute command to run the DTS from the command line.
As I would like to demonstrate this on my website
Since the CFExecute is disabled (a wise decission for any ISP) in the HostMySite environment, I ned to come up with a work arround that will not result in recoding if the customer bys the utility.


Though I am comfortatble creating a SQL Stored procedure to run the DTS, it plays havock with the XML configuration file that runs the CF Application.

Would creating an ASP.Net page with the following code to run the DTS be acceptable?

Dim oAppExec As Object
Dim sAppCommand As String = gDsConfigXML.Tables("RemoteApps").Rows(0).Item("AppPath").ToString() & gDsConfigXML.Tables("RemoteApps").Rows(0).Item("AppCmndLine").ToString()
Try
oAppExec = Shell(sAppCommand, AppWinStyle.NormalNoFocus, False)
Catch evt As Exception
sErrText = "Run Remote App Error: " & Err.Number & "," & vbCrLf & Err.Description.ToString() & vbCrLf & "******************************************" & vbCrLf & vbCrLf
UpdateEventLogs(sErrText, "", 1, 2, 0, 0, 0, 0)
End Try

If so, what authentication mode would I need to set in the web.config security elem, and how would the authentication be passed from my web to the server?.



"Don't look at me, I just randomly flip the bytes & hope they come up heads...."