March 19, 2009 at 1:21 am
Hi Everyone,
Could you please help me in resolving the below issue?
When I am running child SSIS package in parent SSIS package (.dtsx), I am getting following error at the end of execution of package.
DTExec: The package execution returned DTSER_FAILURE (1).
The below error shows when the child package is executed:
Warning: 2009-03-19 00:57:15.10
Code: 0x80019002
Source: Run Child package
Description: The Execution method succeeded, but the number of errors raised (12) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
Warning: 2009-03-19 00:57:15.16
Code: 0x80019002
Source: pkg_Master
Description: The Execution method succeeded, but the number of errors raised (12) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
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 package in it. When I enable the child package task and run the master package, the above error comes.
Hope for your great support.
Thanks in Advance.
March 20, 2009 at 9:17 am
Child package has some dependency that is causing errors that you are not aware of. You should paste the full output of your error window. Check for package configuration differences, variable setting expectations etc.
March 22, 2009 at 11:04 pm
Have you installed SQL Server 2008 recently?
I've seen an error like this when the parent package was being executed in SSIS from SQL Server 2008, but the child packages were being executed in SSIS from SQL Server 2005.
My solution was to explicitly Open With... Execute Package from 2005.
It may not be relevant, but it's quick to check.
April 1, 2009 at 2:50 am
Hi,
Sorry for so long delay...
Below is the error I am getting in my console:
Warning: 2009-04-01 00:57:15.10
Code: 0x80019002
Source: Run Child package
Description: The Execution method succeeded, but the number of errors raised (12) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
Warning: 2009-04-01 00:57:15.16
Code: 0x80019002
Source: pkg_Master
Description: The Execution method succeeded, but the number of errors raised (12) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
I created one simple Master and child packages and executed successfully..Compared this configurations with the one i had issue. Both looks same in configuration.
Coming to variables side, Master package variables and child package variables are different and no variable assignments between these two.
I am using SQL Server 2005 Integration Services and running packages using dtExec command.
Thanks in advance..
Thanks,
umamahesh
April 1, 2009 at 3:02 pm
umamahesh (4/1/2009)
...
Below is the error I am getting in my console:
Warning: 2009-04-01 00:57:15.10
Code: 0x80019002
Source: Run Child package
Description: The Execution method succeeded, but the number of errors raised (12) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
...
I am using SQL Server 2005 Integration Services and running packages using dtExec command.
...
Could you please enable logging on the child package, and let us know what the 12 errors actually are?
April 2, 2009 at 1:39 pm
Hi Tim,
Thanks for your help.
This problem got resolved by removing the unused connection strings from the dtsconfig files.
I have one dtsconfig file, which is used by master and child package and that dtsconfig file has many connection strings and I am not using all those.
On running the child package, the connection strings that are not used are shown as warnings and I think, because of these warnings, child package returns as error with code 1 instead of 0.
Or, the same connection strings used by both master and child that caused this issue.
I do not know how far I am right, but think this is what caused the issue.
Please, correct me if I am wrong?
April 2, 2009 at 2:31 pm
I have seen this issue before - SSIS expects all configurations in an XML file or SQL Server 'filter' to be used in all packages that use the configuration.
June 10, 2010 at 4:38 am
Hi Guys ...
I am experiencing a similiar problem. We have many packages that use a single dtsconfig file. It seems that every connection that has been defined in dtsconfig needs to exist in the package that uses the file. If the connection does not exist in the package but appears in dtsconfig, the package fails on execution.
My issue is that I need to add any new connections that were created in dtsconfig to every existing package as well, even though they are not being used. When there are many packages using a single dtsconfig, this process is quite tedious.
Is there any way around this?
I'd like to continue using a single dtsconfig.
Thanks
June 10, 2010 at 8:07 pm
I think you can Copy and Paste the connections XML between packages to speed up the process.
Otherwise, you'll just have to put up with the extra connections.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply