Hello,

I have a little problem with the security context of DTS.

I explain my problem :

I have 2 DTS, the first DTS is started through an ASP page, No
problem.
The second DTS is executed by the first, but I get an error message,
something like that "user cannot be equal to null". For the two DTS, I
use the user context (value 256 in LoadFromSQL). I cannot change to
SQL authentication, because I copy some files between two servers. The
first DTS extract some data and choose which DTS must be carried out
then.

I don't have any problems when I execute the fisrt DTS through the
Entreprise Manager.

Do you have any idea ?

Thank's for your help.

Since the packages are being run from an ASP page it is possible that the
IIS IWAN account is trying to connect to SQL Server to launch the package.
If this is the case you may have to ensure that the IWAN account has the
necessary permissions.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Thank's for your response, but it's not the case, when the user start the
ASP page, he must provide an authentication and I use the user context to
run the first DTS. The problem occurs between the first and the second DTS.
I use scripting into the first DTS to execute the second DTS.

Regards

"Rand Boyd [MSFT]" <rboyd (AT) onlinemicrosoft (DOT) com> wrote