The package execution returned DTSER_FAILURE (1)

0

I keep getting the error The package execution returned DTSER_FAILURE (1) when executing my job on SQL 2012 using Agent For a test I have a simple script with a message box and it runs fine in Visual Studios 2012. When I run it in SQL Agent I get the above erorr. I did disable the script from running and when I did that it processed in SQL agent without error.

I have clicked the 32 bit button and then unclicked it. I have used a proxy and haven't. Has anyone ran a cross this? Below is the full error message. THanks

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted 09/24/2020 13:26:30,New,Error,,BHI8WNM8S2,New,,,The job failed. The Job was invoked by User BHI-MASTER\olsoandj. The last step to run was step 1 (T1).,00:00:01,0,0,,,,0

09/24/2020 13:26:30,New,Error,1,BHI8WNM8S2,New,T1,,Executed as user: BHI-MASTER\olsoandj. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5583.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 1:26:30 PM Error: 2020-09-24 13:26:30.96 Code: 0x00000001 Source: Script Task Description: Exception has been thrown by the target of an invocation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:26:30 PM Finished: 1:26:30 PM Elapsed: 0.594 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0

sql
ssis
sql-agent
asked on Stack Overflow Sep 24, 2020 by ajolson1964 • edited Sep 24, 2020 by ajolson1964

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0