RE: Incorrect DTS package version run by scheduled job
From: Craig (CraigNicholas_at_online.nospam)
Date: 09/07/04
- Next message: Phil: "DTS Package Change Management Software"
- Previous message: Joe: "Question about DTS error logging"
- In reply to: Craig: "Incorrect DTS package version run by scheduled job"
- Next in thread: Sue Hoegemeier: "Re: Incorrect DTS package version run by scheduled job"
- Reply: Sue Hoegemeier: "Re: Incorrect DTS package version run by scheduled job"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 7 Sep 2004 07:15:03 -0700
I've found the reason why ...
I had scheduled the job on another server and generated a SQL script from
the job.
Then I installed the package on another SQL server and installed the job
from the script. The job was running the DTS package on the original SQL
Server.
I now understand the encrpted DSTRUN command generated is NOT portable.
"Craig" wrote:
> 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
- Next message: Phil: "DTS Package Change Management Software"
- Previous message: Joe: "Question about DTS error logging"
- In reply to: Craig: "Incorrect DTS package version run by scheduled job"
- Next in thread: Sue Hoegemeier: "Re: Incorrect DTS package version run by scheduled job"
- Reply: Sue Hoegemeier: "Re: Incorrect DTS package version run by scheduled job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
