Hello,

I want to populate a table with values that reside in an
Excel file....

Table A
-------
TableIdentifier PK
value2 FK
Description
Item
Part

I want to populate this table with values from an Excel
file... but the Excel file does not have the Foreign key
in it... The Foreign Key resides in a global variable in
my DTS package..

Question: How do I populate the foreign key and the excel
values at the same time? Is this possible?

My route: I am trying to populate the Foreign key first..
then Update Into the table with a SQL Query Task... I have
tried this but not sure where to place the WHERE clause..

Thanks in advance.
niv


.