Post reply

SSIS Package with(Derived Column & Lookup)

  • September 27, 2012 at 4:22 am

    #264920

    Hi All,

    I have a SSIS package that has data in a table. I have a OLE DB Source to connect to the table but i need to do a look up to populate a field within that table. But the field i'm looking up on the destination is nvarchar and the source field is an int and the SSIS componet for look up dosen't allow lookup's with different data types. Can i change this with a derved column ?

    I could change the the data types on the tables but their both populated form external sources.

    Thank you in advance.

  • September 27, 2012 at 4:53 am

    #1542786

    just go to the advanced tab-> output column and change the datatype.

    or

    use the conversion task.;-)

  • September 27, 2012 at 4:54 am

    #1542788

    Have you seent DataConversion task in SSIS pipes, as this seems to be what you are looking for. simply place it after the extractor, and do the conversion on the column, then run that into the Lookup and join on your new converted column.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • September 28, 2012 at 12:11 am

    #1543196

    Before doing the lookup task convert the field to nvarchar using data conversion task 😛

    Business Intelligence

  • September 28, 2012 at 2:24 am

    #1543244

    Cheers guys the conversion task worked a dream.

    In relation to SCC Rookie's comment "just go to the advanced tab-> output column and change the datatype" where should i be looking for this ?

    The reason i ask is so that i know for the future and can cover all permutations.

  • September 28, 2012 at 9:02 am

    #1543471

    I have previously posted a question yesterday and thank you all for your quick response.

    I’ve nearly completed the SSIS package but unfortunately it stalls(doesn't error and have left it for 15 - 20 minutes) at the last step.

    The step that it stalls on is the updating of the lookup values from the lookup. I’ve tried many ways on performing the lookup cache and a query

    I currently have a SSIS with the following

    OLE DB Source

    Data Conversion - (To change my lookup value from int to nvarchar to match it in the lookup)

    Derived Column - (ltrim(rtrim(column)

    Lookup

    OLE DB Destination

    Any ideas ?

Viewing 6 posts - 1 through 5 (of 5 total)

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