Post reply

Need - help to create DLOOKUP with SSIS

  • March 17, 2006 at 10:22 am

    #111453

    Hi,

    Does anybody knows how to create a DLOOKUP (dynamic lookup) in SSIS?

    I need to test records existance in destination from the source before inserting or updating in the destination (if the record exist in destination then update, else insert).

    Any help apreciated.

  • March 20, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 23, 2006 at 6:07 am

    #628313

    I am afraid that SQL Server doesn't has any such feature as Dynamic lookup. However i guess that the slowly changing dimension feature of SQL Server could come handy for the task that you are aiming to accoplish. I have not tried it myself and hence cant assure of the same. I may be excused if you are still left guessing!! 

  • March 26, 2006 at 11:15 pm

    #628815

    I landed with a link suggested by one of the members on this group. It'll solve your issue of DLOOKUPS. http://www.sqlis.com/default.aspx?311 There are 2 methods here - I recommend you use method 2.

     

    Dharam

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

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