I was using the below script on SQL 2005 to bulk insert in query analyser : The problem is that it's not processing the file but the file has got full admin right and the server where am running the script from has got access to the file. but still getting o row affected please help any ideal
BULK INSERT [dbo].[tb_ImportedValueTempImport] FROM '\\ukdc01-ldb-003\OBS$\Rex Import Testing 5 - Rex Testing Imported Value Drilldown - Gold Option - 2007-12-01 to 2007-12-31.txt' WITH ( FIELDTERMINATOR = '|' ,ROWTERMINATOR = '\n' )