Post reply

Using Lookups and sending the failed row to a table -- Issues with the failed column

  • January 21, 2011 at 7:56 am

    #144437

    Hi,

    I have a csv table as the source

    I then have a lookup transformation on column Role.

    the error output is set to redirect row.

    My red arrow goes to an OLE db destination because I have an error table in SQL

    I run the package and it all goes fine. 2 of my records go to the failed table.

    I open the failed table and Role is NULL. Is should have something in it, the incorrect roles.

    How do I get round this???

    Thanks in advance

    Debbie

  • January 24, 2011 at 4:54 pm

    #1277533

    can you be a little more specific .... because its heard to figure

  • January 24, 2011 at 5:02 pm

    #1277539

    Don't use replace column in the lookup, create a new one and use Role2 throughout the rest of the script, just carry Role around with it, unused.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • January 27, 2011 at 3:40 am

    #1278981

    Hi,

    I cant get any more specific on this one.

    I decided to do it all through SQL in an SP. That way I know exactly what is going on. every time I try and use the transformation packages in IS I get put off by something like this happening. :ermm:

    Thanks for the advice though

    Debbie

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

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