Hello,

I'm creating a dts to import data from a textfile to a
table. This table is 'attached' to another table via
constraint because it's a product table ( with a order
table) so I can't empty this table and re-populate it.

Do the best solution for me will be to create a temp
product table, import the textfile in it, and then update
the real table with the temp table?

If yes, how can I do that.. with a stored procedure? How
can I loop through every record of the temp table to
update or insert record to the real table..?

Thanks in advance.