Board index MS SQL Server

DTS Job Problem..

DTS Job Problem..

Post by Narahar » Sat, 03 Nov 2001 06:51:12



I have been executing the jobs ( 2 Jobs, each job consisting of 10 DTS
packages ) for over a year .
Everything appears to work great till two days back.
For the last two days the jobs are failing with the following error message.

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.

When i manually execute all these DTS packages step by step ,these  are
fine.
I am using SQL 7 (SP3) on Windows NT SP6.  Any suggestions would be
appreciated.

Thanks
Narahari

 
 
 
Top

1. DTS/Job problem

I am having a problem with a DTS package not running when done as a
scheduled job.  This is a job that has run many times in the past just
fine.  The only thing I changed was, I redid the transformations in the
DTS package, and instead of typing them in, I imported a .vbs file for
each of the transformations.  The source data is Microsoft Access and
the destination is SQL Server.  The DTS package ran OK when I did it
manually, but fails every time when I try to execute the job.  Here is
the error message (there are 11 DataPumpTasks in this package):

DTSRun:  Executing...
DTSRun OnStart:  DTSStep_DTSDataPumpTask_1
DTSRun OnStart:  DTSStep_DTSDataPumpTask_2
DTSRun OnStart:  DTSStep_DTSDataPumpTask_3
DTSRun OnStart:  DTSStep_DTSDataPumpTask_4
DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147217887
(80040E21)
Error string:  Errors occurred
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
Error Detail Records:      Error:  -2147217887 (80040E21); Provider
Error:  0 (0)
Error string:  Errors occurred
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1
DTSRun OnStart:  DTSStep_DTSDataPumpTask_5
DTSRun OnError:  DTSStep_DTSDataPumpTask_5, Error = -2147217887
(80040E21)
Error string:  Errors occurred
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:        Help context:  0
Error Detail Records...  Process Exit Code 11.  The step failed.

Can anyone help me?

Sent via Deja.com
http://www.deja.com/

2. multiple ODBC cursors with MS Access

3. How can I enter Image data into table?

4. Scheduling DTS jobs problem

5. replication and MS Cluster Server

6. DTS job problem

7. Passing strings to SQL

8. JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS

9. JOBS JOBS JOBS JOBS JOBS JOBS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

10. DTS scheduled job problem

11. DTS scheduled job failing -- not permissions problem!

12. problem with job and multiple DTS


All times are UTC
Board index