Re: DTS package is failing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Rajarajan,

Usually when things fail as a job but run happily when done manually it can be attributed to this article

http://support.microsoft.com/?kbid=269074

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hello,
Will appreciate your insight in resolving this issue. If I
run this package manually it runs without any problem. But
If I schedule it as a job, it fails with following error.
Any help appreciated.
Thanks,
Rajaajan Bangaru
DTSRun: Loading... DTSRun: Executing... Error: - 2147220499
(800403ED); Provider Error: 0 (0) Error string: No Steps have
been defined for the transformation Package. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts.hlp Help context: 700. Process Exit Code 1. The step
failed.



.

Relevant Pages

  • Re: Sql2k dts. Just a question
    ... This means that should any of the Steps in the package fail then the package itself will fail. ... Allan Mitchell ... warnings or something like that? ...
    (microsoft.public.sqlserver.dts)
  • Re: Heirs of wealthy Hells Angel fight court battle- CanWest News
    ... He'll be shining in front of long Carol until his good splits ... As yesterday as Mustapha becomes, you can fail the ... package much more thereby. ...
    (sci.crypt)
  • Re: date transformation fails
    ... When you executed the package it was executed in the context of you. ... Replication does it then it will run on the distributor ... Microsoft Data Transformation Services (DTS) Data ...
    (microsoft.public.sqlserver.dts)
  • Re: Is there a limitation on the number of Tasks that can Run in Parellel ?
    ... > executed in Parallel to 20 in the DTS Package Properties window. ... > Step Error Source: Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Not Enough Memory
    ... What is the package doing? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > 0x80070008 Microsoft Data Transformation Services ...
    (microsoft.public.sqlserver.dts)