SQL Server 2000 - Importing text Files into SQL Server

--Import data into the Hierarchy Table from the Hierarchy.csv file
BULK INSERT Hierarchy 
    FROM 'C:\Sales_Ranking\Hierarchy.csv' 
    WITH 
    ( 
        FIRSTROW = 2, 
        FIELDTERMINATOR = ',', 
        ROWTERMINATOR = '\n' 
)

--Import data into the Hierarchy Table from the Hierarchy.csv file
BULK INSERT Hierarchy 
    FROM 'C:\Sales_Ranking\Hierarchy.csv' 
    WITH 
    ( 
        FIRSTROW = 2, 
        FIELDTERMINATOR = ';', 
        ROWTERMINATOR = '\n' 
)

CREATE TABLE Hierarchy
(
Version_Name char(50), 
Effective_Start_Date datetime, 
Position_Name varchar(200), 
Person_latest varchar(200), 
Parent_Position varchar(200), 
Parent_Person_latest varchar(200)
)

--Bulk Insert data into Hierarchy table
BULK
INSERT Hierarchy
FROM 'c:\Xactly\SourceData\Hierarchy.txt'
WITH
(
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
GO

Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005:  The provider did not give any information about the error.].
The statement has been terminated.