Re: Error when invoking DTS package from ASP.net
From: William Pierce (evalsinca_at_hotmail.com)
Date: 08/26/04
- Next message: Ed: "RE: output"
- Previous message: William Pierce: "Error when invoking DTS package from ASP.net"
- In reply to: William Pierce: "Error when invoking DTS package from ASP.net"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 22:54:41 GMT
All,
I found out the problem. In the statement where I was loading the package,
I needed to use the "Trusted connection" flag instead of the default one.
-- William
"William Pierce" <evalsinca@hotmail.com> wrote in message
news:aFsXc.12603$lr7.1382@newssvr29.news.prodigy.com...
> I have the following setup:
>
> a) IIS, Sql Server 2000 all running on my laptop (WinXP). I am running
> .net 1.1.
>
> b) I have a DTS package. I can execute the DTS package directly from
within
> the Enterprise Manager. It works correctly.
>
> c) I have an ASP.net application which attempts to load and execute the
> package. I get the following error message:
>
> "Exception Details:
System.Runtime.InteropServices.COMException:
> Invalid authorization specification"
>
> and it appears to be objecting to my attempt to load the package. The
line
> that I am using for loading the package is as follows:
>
> p.LoadFromSQLServer("localhost", "", "",
> DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null, null,
> null,"Gard2SDFPackage", ref pVarPersistStgOfHost);
>
> Where p is the package that I have defined.
>
> I use windows authentication for my SQL Server.
>
> Anyone see anything obviously wrong with what I am doing, or my setup?
>
> Thanks,
> William
>
>
- Next message: Ed: "RE: output"
- Previous message: William Pierce: "Error when invoking DTS package from ASP.net"
- In reply to: William Pierce: "Error when invoking DTS package from ASP.net"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
