Re: Errors not raised when DTS package run with DTSRUN

#1

DTS Packages are stored (In the main) in MSDB.

Guest is (In the main) a user in MSDB and therefore is a member of Public

Public has execute permissions on the DTS stored procedures so can execute
packages.

Usually when people can execute things manually but not when scheduled then
this comes into play

http://support.microsoft.com/?kbid=269074

try also turning on "Fail on First Error" in the package properties as quite
often a job will return successful when in fact it failed (The package that
is)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Gordon" <gradley (AT) yacobian (DOT) com> wrote

Quote:

Hi,

I have a DTS package setup locally in SQL Server that has
error trapping for every step that is processed. If I run
this package through Enterprise Manager in SQL Server or
by submitting with SQL Server Agent, when an error occurs,
it is raised and I have it setup to send me an e-mail of
the error. The error is trapped using a VB DLL program
and sent with xp_sendmail.

If I run this package using DTSRUN and an error happens,
it is not raised. The only difference I'm aware of is
that for security reasons, I have a separate User and
password for the DTSRUN command.

Right now this user has no special rights or database
rights (non granted, non revoked). Does anyone know what
the minimal security access should be for users executing
DTS packages from a Windows environment (using DTSRUN). I
would hate to give more access rights than what is needed.

Any help would be greatly appreciated.

Thank you in advance,

Gordon Radley
Senior Software Engineer
The Yacobian Group,LLC.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Errors not raised when DTS package run with DTSRUN

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Errors not raised when DTS package run with DTSRUN - 07-01-2003 , 01:28 AM