My plan was to get the text file and do a Bulk insert into a holder table in Sql server 2000 via the bulk insert command inside a stored procedure.

I want to update a value in a table in a SQL Server Db with a value from one of the fields in the text file. I want to do this based on a query using the second field in the text file.