Incorrect DTS package version run by scheduled job

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Craig (CraigNicholas_at_online.nospam)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 03:19:04 -0700

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

Relevant Pages

  • SQL 2000 - Scheduled Job causes system errors
    ... I have a scheduled job that is causing errors in the System Event Log, ... The job is a DTS package that has two steps -- first step connects to our ... SQL Server error logs, all peachy. ...
    (microsoft.public.sqlserver.dts)
  • Re: Schedule a dts package
    ... Scheduled Job ... Andrew J. Kelly SQL MVP "TS" wrote in message ... > I created a dts package successfully to transfer a number of Visual FPro> tables to SQL. ... > and I am a member of System Administrator role and have dbo permission to> the ...
    (microsoft.public.sqlserver.dts)
  • Re: users logs off pc;dts doesnt run
    ... the job is a scheduled job that runs around 4 AM. ... SQL Server Agent runs the job. ... > I am assuming that he runs the DTS package from his machine when it run ...
    (microsoft.public.sqlserver.server)
  • Re: DTS vs Job Problem for 2 Digit Date format
    ... When you execute the DTS package it is running locally, ... When it runs as from a scheduled job, ... use the settings on the server. ...
    (microsoft.public.sqlserver.dts)
  • Re: scheduling problems
    ... This KB should answer your questions about running DTS as a scheduled job: ... > I am having difficulty scheduling a DTS package to run. ... However, when scheduled, the process fails. ... Populate new table with recs from Excel Table ...
    (microsoft.public.sqlserver.dts)