SQL Agent - 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

  • And where are you expecting the messagebox to be displayed?

    Change your simple script such that it does not require any sort of UI interaction and you should find that it will run.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • That solved the problem.  I changed the script to just right Test to a variable and it ran without issue.  I have troubleshooted this is not some sort of configuration issue between DTSX packages and 2012 environment.

    Then I change the package to run the actual DTSX package that was failing before and I am back to the same error.

    What this package does is import tables from one database to another using VB scripting.    Scans DB A for tables then imports then Creates new tables in DB2 and then imports the data into those tables.

    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/29/2020 09:17:36,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:05,0,0,,,,0

    09/29/2020 09:17:36,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: 9:17:36 AM Error: 2020-09-29 09:17:41.31 Code: 0xC00220E6 Source: Export File to Server Description: There is no project to reference. End Error Error: 2020-09-29 09:17:41.31 Code: 0xC0024107 Source: Export File to Server Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:17:36 AM Finished: 9:17:41 AM Elapsed: 4.532 seconds. The package execution failed. The step failed.,00:00:05,0,0,,,,0

  • Is the package deployed to SSISDB? Did you use the project or package deployment model? Do you use project parameters or connections?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply