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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

DTSER_FAILURE

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?

Pat

 


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:

 

Message
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?


Categories: 
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