Hi,

I've tried adding this function to my ASP pages and get the following
error message;

Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object: 'DTS.Package'

/asp/pages/dts.asp, line 21


Does anyone have any idea what I need to fix to get the DTS to work?

I'm v. new to SQL Server and ASP so any help would be appreciated.


Many thanks,
Chris Dunigan



Dan Guzman wrote:
> You can specify a trusted connection with flag 256 instead of
username and
> password. For example:
>
> DTSPk.LoadFromSQLServer ServerName, , , 256,,,,PackageName
>
> Assuming this is an intranet application running under NT 4.0 and you
want
> to execute the package under the invoking user's account, you can do
this as
> follows:
>
> Specify 'clear text' for the IIS Directory Security
authentication
> Remove 'Everyone' from the access list on the files (requires
NTFS) and
> grant permissions to the users
> Grant logins access to the database server
>
> With this method, users must enter their Domain\UserName and password
when
> prompted.
>
> NT authentication presents a challenge when multiple servers are
involved
> because NT 4.0 does not support delegation. See
> http://msdn.microsoft.com/workshop/s...e/security.asp for
details.
> I understand Windows 2000 provides delegation capabilities but this
can be a
> bit tricky to implement.
>
> BTW, if your DTS package does not access SQL Server, you can save it
to a
> file and use the LoadFromStorageFile method instead.
>
>
> Hope this helps.
>
>
>
>
>
>
> If you need to use
> Chuck Gatto <cgatto@anchorsystems.com> wrote in message
> news:8ekrkd$pmq$1@slb7.atl.mindspring.net...
> > Below code works 100% in VB but the load fails in ASP. I get...
> > "Microsoft OLE DB Provider for SQL Server. Login failed for user
"\".
> error.
> > I think the IIS (server a) is set for NT auth. and sql7 (on server
b) as
> > well but I can't be sure.
> > Any idea what I should look for.
> > Thanks
> >
> >