DTS package failure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS package failure

Author

Topic

saurabhlunia
Starting Member

3 Posts

Posted - 2005-11-14 : 01:24:46

had designed a DTS package and its failing with the following error message. could any one help me out in solving the problem.

Event viewer error message.

Step 'DTSStep_DTSExecuteSQLTask_22' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80040e14): MSA :3013:E:S_BACKUP_IS03_SUBSCRIBER_LOG : Backup of database [MY_database] transaction log failed) (Microsoft OLE DB Provider for SQL Server (80040e14): BACKUP LOG is terminating abnormally.) (Microsoft OLE DB Provider for SQL Server (80040e14): Could not create worker thread.) (Microsoft OLE DB Provider for SQL Server (0): BACKUP LOG successfully processed 0 pages in 0.275 seconds (0.000 MB/sec).)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

Step Execution Started: 13/11/2005 13:12:26
Step Execution Completed: 13/11/2005 13:13:20
Total Step Execution Time: 54.062 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_23' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80040e14): MSA :50000:E:My_database_trnlog : Cant backup My_database Logs)
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

saurabh

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-11-14 : 01:53:38

are you backing up your database from within a DTS package?

saurabhlunia
Starting Member

3 Posts

Posted - 2005-11-14 : 04:11:47

Yes, I am trying to take database backup & transaction log backup from the same DTS package. These DTS use to run successfully earlier but now a days it use to fail with these error.

saurabh

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-11-14 : 11:40:58

can you successfully backup your database outside of the DTS package? btw, I have never heard of anyone using DTS for backups. What else do your DTS packages do?

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources