Hi Everyone,

Does anyone know how to run a DTS pkg. from an ASP page. I do/can not have Admin privileges granted to me, so using the following methods is out:

1. Running using Exec Master..xpcmdshell
2. As a scheduled job
3. Running a Batch file from ASP page (with dtsrun in the batch file)
4. Executing from the ASP page by using a DTS object

Our DBA :( cannot grant admin. rights to us. Any alternative suggestion would be welcome.

Thanks,
KD

Hi

Is the site running on the same server as the SQL DB? If not you could excecute the package from another machine using your own set of dll files. I could send you a list of the dll's and resource files or you could just install Enterprise Manager on that server.

Why do you require admin right to make the ASP/VBS to work? If the IIS user running the page has got rights to the location of the DLL/exe's (SQLBinn) it should work. Normally User group have got access by default to these directories.

If tis doesnt help you in anyway give me some more details of your current setup.

Regards
Marnus

Hello,

One of the solutions I did was use a SQL Service account and used that to execute the package. I tried using a SQL Server login to execute the package, and this didn't work through code. The only way was to use the service account to execute the package through a scheduled task. This was set up by the DBA. Unfortunately, it is this, or use a SQL Server account to execute the xp_cmdShell proc using the dtsrun utility.

You'll need to have privileges to do whatever though.

Brian