Running Dts From Stored Procedure

Hi





I am trying to upload an excel file into a sql server database. I uploading the spreadsheet from an asp.net page and then running the dts froma stored procedure. But it doesn't work, I am totally lost on what I am doing wrong.


Any help would be greatly appreciated.





Asp.net code;





Dim oCmd As SqlCommand





oCmd = New SqlCommand("exportData", rtConn)


oCmd.CommandType = CommandType.StoredProcedure


rtConn.Open()





With oCmd


.CommandType = CommandType.StoredProcedure


Response.write("CommandType.StoredProcedure")


End With





Try


oCmd.ExecuteNonQuery()


Response.write("ExecuteNonQuery")


Finally


rtConn.Close()


End Try





StoredProcedure;





CREATE PROCEDURE exportData AS


Exec master..xp_cmdshell


'DTSRUN /local/DTS_ExamResults'


GO





Thanks


Rachel