Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. SSIS DevOps. dtsx". The following is an example of the path for the MaximumErrorCount property:. The default value of this property is 1". Q&A for work. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. 33. Change the MaximumErrorCount or fix the errors. End Warning DTExec: The package execution. The scenario is similar to the following: - there is an Execute SQL task (which sometimes fails) - there is a Failure constraint on this Execute SQL Task and a retry mechanism, so in the end the same SQL. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. The Execution method succeeded, but the number of errors raised (8) reached the maximum allowed (1); resulting in failure. The default value. The program '[16900] DtsDebugHost. Results. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. indicates the maximum number of errors that can occur before the DtsContainer object stops running" (emphasis mine). This occurs when the number of errors reaches the number specified in MaximumErrorCount. Modify the script: Dts. Next option will not actually fail your tasks, but may work for you: Try wrapping your code into try catch and use finally to set Success for 2 tasks that you don't care about. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. SSIS package "Package. This occurs when the number of errors reaches the number specified in MaximumErrorCount. End Warning Solution : SSIS enginee needs to be there in the server to run the SSIS package . The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. " <o:p></o:p>In SSIS/SSDT, add new Execute Process Task to control flow of your package. Every thing OK. The default value. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. SSIS package. The Execution method succeeded, but the number of errors raised (%1!d!) reached the maximum allowed (%2!d!); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The variable value will be "c:usersjohn_doedownloads". Change the MaximumErrorCount or fix the errors. This occurs when the number of errors reaches the number specified in. dtsx" finished: Failure. Failure 3. Reference [run-sql-server-agent-job-from-ssis] to create sql agent job from SSIS, 2, if you want to backup mutiple dbs automatically, you can also follow steps as this: how-to-backup-multiple-sql-server. Now if you run it and it works the first time, it should run through and exit as shown below. Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The following code example creates a Package, which is a class that inherits from DtsContainer. Change the MaximumErrorCount or fix the errors. Change the MaximumErrorCount or fix the errors. Imports System Imports System. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Option 2, When using Foreach File Enumerator - 'Retrieve. End Warning I am able to run child package successfully with return code of 0 and even run master package successfully when disabling the child. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want to configure. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. dtsx" finished: Failure. 91 sq meters garar… Car Accident On Private Property OhioInformation: 0x4004300B at Loadloadstreams, SSIS. Task failed: Script Task Warning: 0x80019002 at Foreach Loop each User: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Teams. Change the MaximumErrorCount or fix the e rrors. So 1) File System Task Editor (Move File) 2) Script Task (Parse File Name) 3) Execute SQL Task (Insert into DB) Now · Package and Task have a property named. Greg springer, as… Panama City Investment Property Panama City Investment Property . This occurs when the number of errors reaches the number specified in MaximumErrorCount. Let's assume MaximumErrorCount=M=1. Warning: 0x80019002 at Package1: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Unfortunately, the "MaximumErrorCount" property had absolutely no effect on the operation of the task. The Execution method succeeded, but the number of errors raised (9) reached the maximum allowed (1); resulting in failure. The Execution method succeeded, but the number of errors (6) reached the maximum allowed (1); leading to a failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. 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. SqlServer. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. When working with Script Task of SQL Server 2008 Integration Services, it is important to ensure that your custom code complies with the most elementary programming practices. Change the MaximumErrorCount or fix the errors1) Call up filenames from a SQL Table, looping through them one by one. txt. This occurs when the number of errors reaches the number specified in MaximumErrorCount. during backup process). SSIS package "Package1. Script Task Exception Handling in SSIS. This is problem #2. This occurs when the number of errors reaches the number specified in MaximumErrorCount. SSIS package "c:docusign bh pdv triagesql serverssisdocusign bh pdv macro outputBH_PDVM_OutputToExcel. Change the MaximumErrorCount or fix the errors. Reference [run-sql-server-agent-job-from-ssis] to create sql agent job from SSIS, 2, if you want to backup mutiple dbs automatically, you can also follow steps as this:The Execution method succeeded, but the number of errors raised (6) reached the maximum allowed (1); resulting in failure. Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Problem - Copy A Database With The Wizard Of SSIS Feb 27, 2008. Change the MaximumErrorCount or fix the errors. Some times it fails and some time it. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The documentation of MaximumErrorCount-property of a SSIS package is:"The maximum number of errors that can occur before a container stops running. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. dtsx" finished: Failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. dtsx" finished: Failure. Change the MaximumErrorCount or fix the errors. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in MaximumErrorCount. End Warning Warning: 2015-12-09 16:16:02. exe: DTS'. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Information: 0x4004300A at Data Flow Task, SSIS. · After considerable experimentation,. Dts. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. 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. To support parallel execution of different tasks in a package, SSIS uses two properties: MaxConcurrentExecutables and EngineThreads . In the "File name:" section of the File File Connection Manager editor, I want to replace this with a variable. After adding a For Loop container in your Control Flow, you can open its Properties table and set the value of its MaximumErrorCount property to StagingRetryMaxCount + 1. Modify the script: Dts. How To Find A Cave On Your Property How To Find A Cave On Your Property . dtsx" finished: Failure. Let's assume MaximumErrorCount=M=1. I have set the MaximumErrorCount property to 10 for the DataFlowTaks, the SequenceContainer and for the Package but still taks fails and this causes the package to stop. The Execution method succeeded, but the number of errors raised (2) reached the maximum. Change the MaximumErrorCount or fix the errors. h. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Advice?This occurs when the number of errors reaches the number specified in MaximumErrorCount. SSIS package "Package. SSIS package "c:usersdocumentsvisual studio. End Warning Warning: 2015-12-09 16:16:02. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errorsEvent Name: OnWarning Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. dtsx" finished:. Here’s my attempt to help remedy this. Information: 0x40043009 at Loadloadstreams, SSIS. This occurs when the number of errors reaches the. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. Sequence Container 1 ("MaximumErrorCount = 0"): Dimensions Sequence Container 2: Facts I thought when we set "MaximumErrorCount = 0" in a container (Sequence Container 1), the container would execute all its children tasks even if some of them encounter errors, but the at the of completion of the container, its status would be. This occurs when the number of errors reaches the number specified in MaximumErrorCount. 0x80019002 Source: OnPreExecute Description: SSIS. 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. Like I said. Makes are place look trashy plus it is unpleasant to view every time i walk out the door. There’s not much documentation describing this property and the behavior it controls. Change the MaximumErrorCount or fix the errors. dtsx. SSIS silently truncate the dataDownload the filescript used in the Video from below linkSSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Samples { class. dtsx". This occurs when the number of errors reaches the number specified in. SSIS service does not support multi-instance, use just server name instead of "server nameinstance". There are four steps in the package deployment process: . If trash dumping on your property is a problem, at the most extreme, you can put up a fence and then “no. In Solution Explorer, double-click the package to open it in SSIS Designer, or right-click and select View Designer. This occurs when the number of errors reaches the number specified in MaximumErrorCount. how can we solve it?Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. How To Find A Cave On Your Property How To Find A Cave On Your Property . 1. This occurs when the number of errors reaches the number specified in MaximumErrorCount. SSIS package "SSIS_Document_Report. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. What does this mean precisely - what does the statement "container stops running" mean. Thanks Gautam · It cannot be set via a script task. A Microsoft platform for building enterprise-level data integration and data transformations solutions. What does this mean precisely - what does the statement "container stops running" mean. What does this mean precisely - what does the statement "container stops running" mean. Change the MaximumErrorCount or fix the errors. SSIS package "C:UsersUserADocumentsVisual Studio 2015ProjectseSSISeSSISPackage1. dtsx" finished: Failure. Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Change the MaximumErrorCount or fix the errors. Sign in. dtsx" starting. This occurs when the number of errors reaches the number specified in. Teams. If the numbers of errors are less than this parameter, a. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. dtsx » terminé : Échec de l'opération. 3. For example, if you wanted your package to retry 3 times, you would have to set the MaximumErrorCount = 6. SSIS package "C:Visual Studio ProjectenIntegration Services Project1Integration Services Project1Incident categorie Problem. . We can configure sequence container property as well. I have an SSIS package with for each loop > sequence container. On the ForEach Container task, I have the MaximumErrorCount = 0. End. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified. The fix is pretty simple. End Warning DTExec: The package execution. Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. SSIS package "Package. We did not want to do this for our Entire SSIS Package but just for a specific Control Flow Item. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Task failed: Data Flow Task Warning: 0x80019002 at Package1: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. SSIS package "X:SSIS_PkgsSCM_Import_SSIS2015Package. a. SSIS. In this case that means the “Test Connection” task, the “foreach” container and the package itself. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This will stop errors from bubbling up to higher levels in the package. Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREA CHED. Greg springer, as… Panama City Investment Property Panama City Investment Property . SSIS package "c:usersdocumentsvisual studio. End Warning DTExec: The package execution. The process show a warning: Source: SQLSERVERAGENT Catagory: Job Engine Event id: 208 Descripcion: SQL Server. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. dtsx" finished: Failure. This occurs when the number of errors reaches the number specified in. SSIS package "Package4. The Execution method succeeded, but the number of errors raised (10) reached the maximum allowed (1); resulting in failure. We use a data conversion task to change the data type of the source column as per our requirements. and a warning : SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. SSIS package. 33. The Execution method succeeded, but the number of errors raised (17) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. Change the MaximumErrorCount or fix the errors. Whenever the count >500 the process stops to inserts the data into the target table. Connect and share knowledge within a single location that is structured and easy to search. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. This occurs when the number of errors reaches the number specified in. " <o:p></o:p>Change the MaximumErrorCount or fix the errors. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Based on my experimentation, this description is misleading. dtsx" starting. dtsx" finished:. Categories SQL Post navigation. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. The sequence container is trying to read file from For each loop and process its data. Based on my experimentation, this description is misleading. Change the MaximumErrorCount or fix the errors. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Warning: 0x80019002 at PremTaxCounties: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. What does this mean precisely - what does the statement "container stops running" mean. This occurs when the number of errors reaches the number specified in MaximumErrorCount. dtsx" finished:. SSIS package "Package2. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in. SSIS package "C:UsersA670814DocumentsVisual Studio 2015ProjectsIntegration Services Project1Integration Services Project1NDCS Towers. you can use this variable as source connection variable. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the ForEach Enumerator cannot enumerate. · If MaximumErrorCount is. Each task in a Maintenance Plan has a variety of options that can be changed by right-clicking the desired task, then selecting the "Properties" option from the context-menu. · If MaximumErrorCount is. Change the MaximumErrorCount or fix the errors. In the dialog, enable the system variables. Change the MaximumErrorCount or fix the errors. SSIS package "c:\users\*documentsvisual studio 2015Projects utorials utorialsasicpackage. 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. Change the MaximumErrorCount or fix the errors. Package still return failure. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. 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. dtsx" finished: Failure. The Package shows the use of several inherited properties. SQL Server Integration Services. I'm a beginer with SSIS . The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. Pipeline: "temp_load_streams" wrote 0 rows. There is an easier way though. Change the MaximumErrorCount or fix the errors. The default value of this property is 1". Information: 0x40043009 at Loadloadstreams, SSIS. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. This occurs when the number of errors reaches the number specified in MaximumErrorCount. SSIS package "Package. This occurs when the number of errors reaches the number specified in MaximumErrorCount. 8 thoughts on “ Understanding MaximumErrorCount ” eric81 December 2, 2015 at 1:56 pm. Parallel execution in SSIS improves performance on computers that have multiple physical or logical processors. . The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. Warning: 0x80019002 at OpschoonProces: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. SSIS package "Package. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the errors. SSIS package "LnServAccrualInfo. Try setting FailPackageOnFailure to False in the Task's Properties. resulting in failure. Change the MaximumErrorCount or fix t he errors. With the help of. Is it possible to get or set the value of MaximumErrorCount through a script task ? I tried to assign User variables to MaximumErrorCount but could not succeed. Warning 0x80019002: Data Flow Task 3: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. This occurs when the number of errors reaches the number specified in. Change the MaximumErrorCount or fix the errors. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. 33. If you are like me, you probably did not. The default value of this property is 1. . This occurs when the number of errors reaches the number specified in MaximumErrorCount. Run the. The default value. Tasks. Change the MaximumErrorCount or fix the errors. Change the MaximumErrorCount or fix the errors. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. dtsx" finished: Failure. Let's assume MaximumErrorCount=M=1. SSIS package "sData. Maximumerrorcount Property In Ssis . This occurs when the number of errors reaches the number specified in. End Warning DTExec: The package execution. Greg springer, as… Panama City Investment Property Panama City Investment Property . Greg springer, as… Panama City Investment Property Panama City Investment Property . This occurs when the number of errors reaches the number specified in MaximumErrorCount. Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREA CHED. Task failed: EPT Python the thing Warning: 0x80019002 at SEQC Do the thing: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Otherwise, I would never know about any other errors. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Change the MaximumErrorCount or fix the e rrors. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. The default value of this property is 1". This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. So first, Problem #1. This occurs when the number of errors reaches the number specified in. This occurs when the number of errors reaches the number specified in MaximumErrorCount. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. SSIS package "Variety FTD Extract. This occurs when the number of errors reaches the number specifie d in MaximumErrorCount. Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the. SSIS package. Generic Imports System. End Warning Warning: 0x80019002 at File System Task: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. : 0xC0008445-1073707963 : DTS_E_SCRIPTMIGRATIONFAILED64BIT : Migration for VSA scripts can not be done on 64 bit platforms due to lack of Visual Tools for Applications designer support. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. Any type of help will be appriciated. Warning: 0x80019002 at Script Task: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. dtsx". End Warning DTExec: The package execution. End Warning DTExec: The package execution. 13 Code: 0x80019002 Source: DataImport Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in. SSIS package "C:Visual Studio ProjectenIntegration Services Project1Integration Services Project1Incident categorie Nt St Change. this has been running fine. dtsx" finished: Failure. But when i create job schedule task in SQL Server job (Agent). End Warning DTExec: The package execution. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. If any tasks inside the For Loop Container fail, then the package must fail -- except for the Execute Package task (that calls a child package). This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in. This occurs when the number of errors reaches the number specified in MaximumErrorCount. This occurs when the number of errors reaches the number specified in. Examples. 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. Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The documentation of MaximumErrorCount-property of a SSIS package is:"The maximum number of errors that can occur before a container stops running. The package will fail even if all the tasks have the MaximumErrorCount set to 9999 as the package itself needs the MaximumErrorCount set to a higher number other than 1. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the. 64 Code: 0x80019002 Source: Package Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. This occurs when the number of errors reaches the number specified in. I got this error message after running my SSIS package. I simply re-opened the SSIS Package in Visual Studio and now it seems as though this is erroring out. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. Set package properties in the Properties window. SSIS For Loop Container Runs Successfully But Data Flow Tasks and Scripts Inside of the Loop Intermittently Run. The Execution method succeeded, but the number of errors raised (3) reached the. 警告: 0x80019002 at Package: SSIS 警告コード DTS_W_MAXIMUMERRORCOUNTREACHED。 実行メソッドは成功しましたが、発生したエラーの数 (3) が許容される最大数 (1) に達したため、失敗となりました。エラーの数がMaximumErrorCountで指定された数に達すると発生する。 Sequence Container 1 ("MaximumErrorCount = 0"): Dimensions Sequence Container 2: Facts I thought when we set "MaximumErrorCount = 0" in a container (Sequence Container 1), the container would execute all its children tasks even if some of them encounter errors, but the at the of completion of the container, its status would be "error" so that. Change the RetainSameConnection property to True.