create table #x... bulk insert into #x... insert into PartsMaster select *, 'prg_old_3000 server.txt' from #x>I'm not doing an insert into the column, I'm doing an update (below the BULK INSERT command).
>>>DROP TABLE PartsMaster >>> >>>CREATE TABLE PartsMaster >>>( >>> Product_Series VARCHAR(75), >>> Product_Number VARCHAR(25), >>> Product_Name VARCHAR(75), >>> Part_Number VARCHAR(50), >>> Category VARCHAR(50), >>> Keyword VARCHAR(50), >>> Part_Description TEXT, >>> Description TEXT, >>> New_part_Number VARCHAR(25), >>> Source_File VARCHAR(50) >>>) >>> >>>DELETE FROM PartsMaster >>> >>>BULK INSERT PartsMaster >>> FROM 'D:\Projects\Clients\Abtech\Parts List\Data\Source\prg_old_3000 server.txt' >>> WITH >>> ( >>> FIELDTERMINATOR = '^', >>> ROWTERMINATOR = '\n' >>> ) >>> >>>UPDATE PartsMaster SET Source_File = 'prg_old_3000 server.txt' WHERE Source_File = '' >>>>>>