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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?