Insert with foreign key


  • Hi All,

    My pkg have a Data Flow with two connections Source= FoxPro and Destination =sql server.

    Destination table is customers with foreign key address_id of addresses table.

    In addresses table I have the customer_id as temp field.

    How can I get the foreign key of address_id at the time of loading the data from source customer table.

    Derived Column can use a variable to set the value of a column, or can I set the value using a select statement?

    I hope this is clear, any ideas?


    Saturday, November 16, 2013 7:27 PM

All replies

  • Sorry, I posted this question to the wrong forum. Can Anyone move this to the Integration Services forum please?
    • Edited by JFBconsul Saturday, November 16, 2013 7:29 PM
    Saturday, November 16, 2013 7:29 PM