I changed my methodology. I am using a stored procedure. Activate the
stored procedure from ASP. Stored Procedure activates DTS. Seems to get
around security issues.
--
bnhcomputing
"Dave" wrote:
> If you are using asp/iis.
>
> Assuming you are using anonymous access, you already have these two accounts
> set up: IWAM_<machine name>, IUSR_<machine name>
>
> These two accounts need to have permission to your SQL server database.
>
> David
>
> "bnhcomputing" wrote:
>
> > I have a completed DTS package in my SQL server.
> >
> > The examples talk about creating and executing a DTS from VB, but no
> > connection information is ever provided. I just want to execute the
> > already existing package, not create another.
> >
> > I would REALLY like to execute the package, that’s already in my SQL
> > server, from an ASP. Does anyone have an example / documentation on
> > how to simply execute an already existing DTS from VB or an ASP?
> >
> >
> > --
> > bnhcomputing >> Stay informed about: How to execute a DTS script