Re: DTS Package not running

One more thing. Under the jobs it says executing and it can run for hours.
When you cancel the job it does not give error but saus job was canceled by
user. Sounds like it executes the job and just stay hung and does not do
anything. When I run the job through DTSRUNUI it runs but when I schedule the
job from same screen it just says executing and nithing happens.
Please help

Thanks

"Andy" wrote:

> Thanks Allan,
> No schedule has not expire. The DTS does not period. I created new DTS just
> something as simple as exporting the output of one table to text file. And
> when I schedule it does not run. But I can run the same package from DTS by
> right clicking and Executing. I can run other schedule job for e.g backup or
> dbcc commands etc.. and it tuns fine. Its just the DTS job cannot be run
> through schedule job.
> Any other input will br great.
>
> "Allan Mitchell" wrote:
>
> > Couple of things to try first.
> >
> > 1. Check the schedule has not expired
> > 2. Check the permissions and job owner has not changed
> > 3. Do you use the ~/Z switch? If you do and use the SQL Server
> > authentication to retrieve your packages from SQL Server have those
> > perms changed?/Password changed?
> > 4. Have you tried constructing a new job string (DTSRUN)? Try using
> > DTSRUNUI.
> >
> > Allan
> >
> > "Andy" <Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:09728A12-B2AF-4A82-8B3A-E60B4C91BDA7@xxxxxxxxxxxxx:
> >
> > > Hi All,
> > >
> > > Suddenly I am not able to run any DTS packages through my schedule jobs.
> > > I
> > > can run the jobs that does not have DTS package but if the job is DTS
> > > package
> > > I cannot run. I can go to DTS and execute the package and it works fine.
> > > Something is out of sink. I have been trying for over a week without any
> > > luck. Please help its getting very frustrating. I need desperate help.
> > > no changes had been made in last several months (to my knowledge) There
> > > are
> > > network guys who have access to the server. But no one is speaking.
> > > I am running Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
> > > 2002
> > > 14:22:05 Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack
> > > 4)
> > >
> > > Thanks in advance
> >
> >
.

Relevant Pages

  • Re: DTS job error
    ... the DTS schedule package functionality - you right click on ... the package on select Schedule Package. ... DTSRUN /~Zxxxxxxxxxxxx. ...
    (microsoft.public.sqlserver.server)
  • Re: Scheduling DTS Packages on 64-bit SQL Server
    ... My understanding is that DTS components are not available for 64-bit SQL ... > I found the following comment on Microsoft's website in regards to scheduling> a DTS package on a 64-bit SQL Server installation. ... do I need> to buy a 32-bit copy of SQL Server to store my packages on to be able to> schedule them? ...
    (microsoft.public.sqlserver.dts)
  • Re: execute dts package and overwrite access table
    ... www.SQLDTS.com - The site for all your DTS needs. ... > I am trying to execute a dts package from a scheduled job, ... > when i schedule the job from the package it appears in the ... > overwrite rather than append in my dts package... ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Package not running
    ... Also try setting the tasks to "Execute On Main Package Thread" in the workflow properties also. ... When I run the job through DTSRUNUI it runs but when I schedule the job from same screen it just says executing and nithing happens. ... I created new DTS just> something as simple as exporting the output of one table to text file. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS vs SP: Is there a performance difference?
    ... >VBScript using DTSrun.exe opposed to directly executing the stored procedure ... I am using a an OLE DB Connection within the DTS package for my ... then no the proc should run the same. ...
    (microsoft.public.sqlserver.dts)