How would anyone go about importing rows into two tables from one flat file. One row contains an attribute for an insert - "I"; one row contains an attribute for an update - "U". I would like the updates to go to one table and the inserts to go to another. How can I accomplish this with a text source and a transform. If it can't be done this simply would you place an instead of trigger on the one table and dump all the records into it. When it finds one with an I or U have it inserted into the other table ?

Hello joelhelms,

This is so much easier in SSIS

http://www.sqlis.com/default.aspx?54

but you are i presume you are using 2K. You can use Lookups to achieve what
you want. You can also use the Data Drivern Query Task.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com