.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server

The package execution returned DTSER_FAILURE


I have a database throwing this error when DBCC CheckDB is run. Can I make an empty database, restore one in error, run repair with data loss and see what happens. Will SQL Server tell me if there is data loss?



PatM Reno

View Complete Post

More Related Resource Links

The package execution returned DTSER_FAILURE (1).


Hi, I have a problem with my SQL 2005 Transactionlog backup. I get an error on the schedule job:


Executed as user: TNET\sqlservice. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  01:00:00  Progress: 2008-02-15 01:00:02.56     Source: {8277BBE5-6B5E-44D1-9221-17442AB5C857}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete  End Progress  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  01:00:00  Finished: 01:00:03  Elapsed:  2.813 seconds.  The package execution failed.  The step failed.


but the job goe's trough and the full backup is ok.

The version I have is 3042 and sp2. Doe's anybody regognize this?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend