Re: DTS scheduled job failed..

#1

One thing I never do is encrypt the command line like this. Determining
what package it is becomes a nightmare (you have to watch what it does).

Can you rebuild the cmdline using an unencrypted line ?

--

----------------------------
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

"Lin Zhang" <zhanglin (AT) mdanderson (DOT) org> wrote

Quote:

I run a package manualy on this SQL server 2000 standard
edition with SP3, it runs without any problem. But if I
schedule it as a job. It fails with the following error:

=============
DTSRun: Loading... Process Exit Code 1. The step failed.
============

And I look anywhere like display error log from SQL Server
Agent, I could not find any more detail error.

If I run this job from Query Analyser by following script:
----
declare @cmd sysname
set @cmd
='DTSRun /~Z0xADB5ACEA8C1FAB411AF671EBB2F5B22070A44BBF04F7B
9013B1E14C4AEDE400AB1F9679567BF7CC9861ABBBE1653347 CE425ADCD
A23482504478CB2ED33F8601423B3AA70B6A2DDA36A44D6AB0 49E6D1EEE
7A079ED9DAD16B8A8CB50923AA438AD5EA57DA1C813D3D6A29 0'
exec master..xp_cmdshell @cmd
-----------

It gives me the following error:

*************
DTSRun: Error decrypting parameter (80090005). Bad Data.
**************

But if I use the same cmd to run from command line, it
works fine. Any help would be appreciated.

Lin Zhang

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

Re: DTS scheduled job failed..

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

Re: DTS scheduled job failed.. - 07-16-2003 , 06:23 AM