Actually I just realized that I think I missed some columns in the CREATE TABLE, so the data in those column(s) is ending up in the Source_File, and is probably overflowing it.




>Kevin,
>
>If each line of your file doesn't end with ^^ to mean empty last column then bulk insert won't work. If that column isn't supplied you'd be better off creating a #temp table that matches the structure of the file, bulk inserting into it and then use an insert - select into the real table
>
>

>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).
>>The name I'm trying to add to the row is 23 characters long.
>>
>>
>>
>>>It looks like the values you're trying to insert into Source_File column are longer than 50 characters.
>>>
>>>>I have the following:
>>>>

>>>>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 = ''
>>>>

>>>>
>>>>If I leave the 'Source_File' off the CREATE TABLE command and don't try to update the source file name, this all works fine. If I include the source file, SQL errors with
>>>>"Bulk load data conversion error (truncation) for row 1, column 10 (Source_File)."
>>>>
>>>>There are multiple lines of the same error, each with varying line numbers.
>>>>
>>>>Anyone know what I'm doing wrong?