ranta
Programmer
- Jun 24, 2003
- 30
Hi,
Hopefully someone can help me here, I have a stored procedure which is running a bulk insert statement to copy records from a CSV format file into an SQL server table. This has been working perfectly well until recently, the code has not changed but the operating system on the server has been upgraded to Windows 2003 which includes MDAC 2.8, does anyone know if this causes problems with the bulk Insert statement.
The Insert statement does not return any errors to the SP, it simply terminates it.
Here is the statement I am trying to run;
BULK INSERT dbo.NA_112003_LICENSING FROM 'c:\bulk\pos\US\licensing\NA_112003_LICENSING.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n', FIRSTROW =2 )
Any help will be much appreciated.
Thanks,
Rory
Hopefully someone can help me here, I have a stored procedure which is running a bulk insert statement to copy records from a CSV format file into an SQL server table. This has been working perfectly well until recently, the code has not changed but the operating system on the server has been upgraded to Windows 2003 which includes MDAC 2.8, does anyone know if this causes problems with the bulk Insert statement.
The Insert statement does not return any errors to the SP, it simply terminates it.
Here is the statement I am trying to run;
BULK INSERT dbo.NA_112003_LICENSING FROM 'c:\bulk\pos\US\licensing\NA_112003_LICENSING.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n', FIRSTROW =2 )
Any help will be much appreciated.
Thanks,
Rory