DTS Run

From: Joel (joel.naze_at_aemc.net)
Date: 06/14/04 

Date: 14 Jun 2004 05:40:24 -0700

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.

Relevant Pages

  • Re: Scheduled DTS package fails even when SQLSERVERAGENT logs on as ow
    ... > And in what DB role on SQL Server is domain\user1? ... > www.SQLDTS.com - The site for all your DTS needs. ... >> Successful DTS package fails when scheduled as a SQL Agent job. ... >> between Agent and DTS security context as far as Access is concerned? ...
    (microsoft.public.sqlserver.dts)
  • Re: DATA Export
    ... When you run DTS package manually it runs in your security context. ... Check the security settings in scheduling program. ... If I use the SQL planer, ...
    (microsoft.public.sqlserver.dts)
  • Re: Security Issues using DTS package to refresh remote/DMZ website
    ... DTS runs and what you have exposed to that security context. ... analyze what the pipe you have opened potentially exposes to the outside ... customer info is sensitive) from a SQL Server on our internal network ...
    (microsoft.public.sqlserver.security)
  • RE: DTS which used to process a cube now fails??
    ... One of the differences between running the DTS using Enterprise Manager and ... running the DTS as a job, is the user context. ... I looked at the detais of the scheduled job and in summary this is the message that it shows: ...
    (microsoft.public.sqlserver.olap)
  • Re: Scheduled DTS package fails even when SQLSERVERAGENT logs on as ow
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >> www.SQLDTS.com - The site for all your DTS needs. ... >>> between Agent and DTS security context as far as Access is concerned? ...
    (microsoft.public.sqlserver.dts)