The package execution returned DTSER_FAILURE (1).

Question

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?

Answer 1

Hi there, I just fixed it. Strange I delete the job and made another. Whola it works.

 

Answer 2

 

Luck you.

I deleted it few times and still gave me this error.

Answer 3

YiQun,

 

Can you add a log file to the job and execute the same. Analyse the log file, you can get more info about the failure!!

 

Answer 4

Hi:

I had the same issue, I'm using an FTP:
Executed as user: ... turned DTSER_FAILURE (1).  Started:  5:00:01 AM  Finished: 5:00:03 AM  Elapsed:  2.625 seconds.  The package execution failed.  The step failed.

I log on remotely to the server and run it from IS, I had an error said like:
Error: The File name "....txt" specified in the connection was not valid
Error: Connection "....txt" failed validation.
....
Error: SSIS Error Code_DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquiredConnection method call to the conection manager "...xls", failed with error code...

1. Check if your user have privelages to run the SSIS and access to all the files.
2. Check the parameters for the job.

I Check the Job and notice review the path for the config file, this was wrong, so, I changed for the right one and works fine.

Server: 9.0.3159
Bits: 32

Regards.

Answer 5

Hello all, we are getting the following error when running our DTS package. Let me know if anyone can make sense of it. Thanks.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>dtexec.exe /FILE "D:\ESP_APPS\
ESP_PROG\WMGT_CMMT_03300_CIMMT_DAILY_LOAD\prod\DTSX\DTS_NFSNameAddress_Daily.dts
x" /CONNECTION "Microsoft OLE DB Provider for SQL Server";"Data Source=DBSRV1
2;User ID=Transfer;Initial Catalog=Transfer;Provider=SQLOLEDB.1;Password=
P@ssw0rd1;" /CONNECTION "Microsoft OLE DB Provider for SQL Server 2";"Data Sou
rce=DBSRV2;User ID=Mgt;Initial Catalog=Mgt;Provider=SQLOLEDB.1;Pa
ssword=P@ssw0rd1;"  /MAXCONCURRENT " -1 " /CHECKPOINTING OFF  /REPORTING EWCDI
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  7:41:31 AM
Info: 2009-08-14 07:41:49.10
   Code: 0x4004300A
   Source: DTSTask_DTSDataPumpTask_1 DTS.Pipeline
   Description: Validation phase is beginning.
End Info
Error: 2009-08-14 07:41:51.18
   Code: 0xC0048006
   Source: ActiveX Script Task  undefined ActiveX Script Task
   Description: Retrieving the file name for a component failed with error code
0x01CD32AC.
End Error
Warning: 2009-08-14 07:41:51.20
   Code: 0x80019002
   Source: DTS_NFSNameAddress_Daily
   Description: The Execution method succeeded, but the number of errors raised
(1) reached the maximum allowed (1); resulting in failure. This occurs when the
number of errors reaches the number specified in MaximumErrorCount. Change the M
aximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  7:41:31 AM
Finished: 7:41:51 AM
Elapsed:  19.391 seconds

C:\Program Files\Microsoft SQL Server\90\DTS\Binn>

Answer 6

Same with me. I deleted the Maintenance Plan and created it again. Its working now!!!