Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: DTS schedule job fails urgent pls help!!!

    Hi all,

    We have created DTS jobs which copies data from one server to another and truncates the destination before copying the data from source. when we run the job manually it runs fine, but when schedule its failing with the below errors.


    DTSRun: Loading...DTSRun: Executing...DTSRun
    OnStart: DTSStep_DTSExecuteSQLTask_1DTSRun OnFinish:
    DTSStep_DTSExecuteSQLTask_1DTSRun OnStart: Copy Data
    from CustomerMaster to
    [OUTBOUND].[dbo].[CustomerMaster]
    StepDTSRun OnError: Copy Data from CustomerMaster
    to [OUTBOUND].[dbo].[CustomerMaster]
    Step, Error = -2147008507 (80074005) Error string:
    Unspecified error Error source: Microsoft Data
    Transformation Services (DTS) Package Help file:
    sqldts.hlp Help context: 1100Error Detail
    Records:Error: -2147008507 (80074005); Provider
    Error: 0 (0) Error string: Unspecified error
    Error source: Microsoft Data Transformation Services
    (DTS) Package Help file: sqldts.hlp Help context:
    1100Error: -2147467259 (80004005); Provider Error:
    0 (0) Error string: Timeout expired Error source:
    Microsoft OLE DB Provider for SQL Server Help file:
    Help context: 0DTSRun OnFinish: Copy Data from
    CustomerMaster to
    [OUTBOUND].[dbo].[CustomerMaster]
    StepDTSRun: Package execution complete.
    please suggest to over come this problem.


    TIA

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My guess is that the DTS job is scheduled to run as a different NT logon than the one you are using to test it interactively. The scheduled logon is probably missing one or more permissions needed for the DTS package.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •