Post reply

Foreign key and SSIS

  • July 20, 2009 at 4:44 pm

    #136716

    Hi,

    I have to populate a table(table1) from flat file.

    One of the fields is foreign key i.e. it refers table2.

    The flat file has the foreign key missing so I have to populate it with the help of table2.

    what is the general way to do it ?

    Thanks in advance.

  • July 20, 2009 at 5:00 pm

    #1027345

    Use a Lookup transformation in your data flow. Use the values in the file to lookup the FK value in your second table.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

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