Hi
I have scheduled a DTS package which works fine.
The last step in the package is a T-SQL task.
I changed the T-SQL task and reran the scheduled job but it ran the original
version.
I removed the original version but the scheduled job still ran the original
version.
I restarted SQL Agent and SQL Server but the result is the same.

Any suggestions?
--
Regards,
Craig

Thanks for posting back Craig. I never use the functionality of right
clicking on a package and use the Schedule Package. The encrypted
command line can make it difficult to troubleshoot job issues or to
move the jobs to other servers. I generally set packages up as jobs by
manually creating the job and the dtsrun command and using windows
authentication for the login. There isn't much that needs to be
encrypted then - unless you don't want job owners or sysadmins to know
what package is running in which job.

-Sue

On Tue, 7 Sep 2004 07:15:03 -0700, "Craig"
<CraigNicholas (AT) online (DOT) nospam> wrote:

In message <siprj05t5k56tsn0f1k2b2rgvqn6301dvm (AT) 4ax (DOT) com>, Sue Hoegemeier
<Sue_H (AT) nomail (DOT) please> writes
I'm with Sue on this one, rarely any need for encrypted command lines.
You may find this useful for manually building command lines-

Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I would prefer it if the Generate SQL Script option did not generate an
encrypted command line.

Regards
Craig

"Darren Green" wrote:

Which Generate SQL Script?

If you are referring to the script you get when you Right Click | Schedule a
DTS package then personally I would use DTSRUNUI to generate a cmdline for
me. You can then choose to use encrypted or not but as you can see
encrypted has its drwbacks.





--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Craig" <CraigNicholas (AT) online (DOT) nospam> wrote