Post reply

Error executing DTSX package from within a parent DTSX package

  • September 19, 2008 at 7:54 am

    #126509

    I am working with an existing SSIS package application which calls several child DTSX packages. I am getting an error when the first child package is being called and I am not quite sure were to go as the error appears to be somewhat generic. Here it is:

    Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (8) 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.

    This message doesn't really tell me what the errors are specifically I am hoping someone has encountered this before and maybe has a clue what it could be.

    I am working on an app which I have inherited and asked to fix. I will admit a lot of what I see is currently above my level of expertise but I am looking to tackle this Goliath one object at a time. 🙂

    Appreciate any help -- thanks in advance.

  • September 19, 2008 at 8:43 am

    #874276

    Right-click in the control flow of your packages and turn on logging. You need to log the errors in both the parent and child packages to really determine what the problem is.

  • September 19, 2008 at 8:54 am

    #874285

    Thanks Michael,

    I appear to have something to work with now -- I will let you know the outcome.

    Cheers,

  • September 23, 2008 at 7:32 am

    #875634

    The first issue appeared to be with my source files being imported with different delimeters than what was expected by the package -- Resolved.

    I have a new issue now and that is my package fails with the following error:

    OnErrorMyServer\serverAD My_Object{F63BA2F3-E28F-4142-98D8-0E631F8D0D3A}{31AB7571-ECB2-4591-BFE1-CC8D59739230}Data conversion failed while converting column "Some_Column" (5017) to column "Copy of Some_Column" (6373). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

    I have checked 2 items number 1 I looked at the source column which was data type nvarchar(128) and the destination converted column which was string[DT_STR] (50) I changed it to string[DT_STR] (128) this didn't help. I looked at the values in the fields and removed all spaces and suspicious characters i.e. "-" but that didn't help either.

    Any suggestions out there?

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

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