Run DTS from ASP
Does anyone know what it takes to execute a DTS package from classic ASP?
I know it involves IIS and DTS permissions and specific ASP codes. But I don't know exactly what needs to be done on IIS, DTS (or SQL Server) and ASP codes.
I'm trying to use LoadFromSQLServer from ASP and I use NT authentication in IIS. But I know little about DTS. Can someone show me the right way to make it work?
One of the error messages I've received currently is, "Step [DTSStep_DTSDataPumpTask_1] failed". In another try, I hardcoded my NT login and password, which has is a SQL Server Admin, but it doesn't work either. I have read MSDN how-to, but I just don't understand it.
Please help.
|