Post reply

Error executing DTSX package from within a parent DTSX package

  • 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 3 posts - 1 through 4 (of 4 total)

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