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.
| Author |
Topic |
|
saurabhlunia
Starting Member
3 Posts |
 Posted - 2005-11-14 : 01:21:11
|
| I 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' failedStep Error Source: Microsoft Data Transformation Services (DTS) PackageStep 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: 8004043BStep Error Help File:sqldts80.hlpStep Error Help Context ID:1100Step Execution Started: 13/11/2005 13:12:26Step Execution Completed: 13/11/2005 13:13:20Total Step Execution Time: 54.062 secondsProgress count in Step: 0Step 'DTSStep_DTSExecuteSQLTask_23' failedStep Error Source: Microsoft Data Transformation Services (DTS) PackageStep 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: 8004043BStep Error Help File:sqldts80.hlpStep Error Help Context ID:1100saurabh |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
DTS failure