Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: Problems running Package as Job in SQL Server 7.0

    I have a package,when it runs as a job ,somtimes it fails,but when I run
    it manually later,it works.Here is the error log:
    DTSRun: Loading...
    DTSRun: Executing...
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4
    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4
    DTSRun OnStart: DTSStep_DTSDataPumpTask_2
    DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 71 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 71
    DTSRun OnFinish: DTSStep_DTSDataPumpTask_2
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5
    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6
    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_13
    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_13
    DTSRun OnStart: DTSStep_DTSDataPumpTask_5
    DTSRun OnProgress: DTSStep_DTSDataPumpTask_5; 92 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 92
    DTSRun OnFinish: DTSStep_DTSDataPumpTask_5
    DTSRun OnStart: DTSStep_DTSExecuteSQLTask_14
    DTSRun OnError: DTSStep_DTSExecuteSQLTask_14, Error = -2147217873 (80040E2F)
    Error string: The statement has been terminated.
    Error source: Microsoft OLE DB Provider for SQL Server
    Help file:
    Help context: 0
    Error Detail Records:
    Error: -2147217873 (80040E2F); Provider Error: 3621 (E25)
    Error string:
    Error source:
    Help file:
    Help context: 0
    Error: -2147217873 (80040E2F); Provider Error: 2627 (A43)
    Error string:
    Error source:
    Help file:
    Help context: 0
    DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_14
    DTSRun: Package execution complete.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is step 14 doing ? This error usually relates to null issues and/or identity columns.

Posting Permissions

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