BizTron – He has to take records from a file, compare them with values in a table and move the results to another table.
It appears that the file data only has to get into the database and then all of the compare and table load can be done there.
Wouldn't it be easier to DTS the file in to SQL Server and then trigger a sproc to do the compare with the first table and the insert into the second table?
-wa