When running this script:
USE Data_Track
SET QUOTED_IDENTIFIER OFF
declare @filepath varchar (100),@SQLIN varchar(500)
Select @filepath = 'C:\ADSEMPS.TXT'
Set @SQLIN = "BULK INSERT t_emp FROM '"+@filepath+"' WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\r\n')"
EXEC (@SQLIN)
I get the error:
Msg 4866, Level 16, State 1, Line 1
The bulk load failed. The column is too long in the data file for row 1, column 8. Verify that the field terminator and row terminator are specified correctly.
The data file looks like this:
SAN372|SANCHEZ GARCIA |ISIDRO | | 8.07|880330| | |
SA4011|SARMIENTO |JAVIER | | 8.07|390089| | |
SOL401|SOLIS |JOSHUA |DAVID | 8.25|E09477| | |
S81007|SOLIS |RACHEL |R | 8.25|E09143| | |
SOS201|SOSA |DAVID |ANDREW | 13.10|E09175| | |
TRU001|TRUJILLO |TERESA |D. | 8.07|E09677| | |
WEE231|WEEKS |ERNEST |S | 8.07|602532| | |
5650AC|ACEVEDO FELIPE |OMAR | | 9.94|631838|CR| |
ACU001|ACUNA GARCIA |DAVID | | 9.94|632324|CR|F|
4623AD|ADAME MARTINEZ |LEONOR | | 9.94|631849|CR| |
7657AG|AGUILAR |ROBERTO | | 9.94|631458|CR| |
2623AG|AGUILERA |FERNANDO | | 9.94|631782|CR| |
7636AL|ALEJANDREZ |RIGOBERTO | | 9.94|631827|CR| |
4023AL|ALVARADO |JESUS |E. | 9.94|631796|CR| |
What am I doing wrong?