I am trying to invoke a dts from asp.net and was informed that I need to create a name key pair file and runtime callable wrapper....which consiste sof changing the command line...but I cannot fine the files. I am using web matrix...which I think is the problem.
Has anyone found the same problems...I am looking for the Bin directory in web matrix and tlbimp.exe.
Well the way I normally run a dts package from asp (and it will work from asp.Net as well) is to create a job to execute the package and then (whenever I want to run it) I make an ADO call to the database using sp_start_job.
Now I know there is another stored proc or something that other people use to run the specific dts (and thus you don't need a job) but I can't remember what it was.
If you want to run things from the command line, why not use dtsrun to execute your package?