Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
devisetti
Starting Member
30 Posts |
 Posted - 2008-10-08 : 00:39:14
|
| Hi I am trying to bulk insert from the following drive.BULK INSERT dbo.T_BS_XYZ FROM 'H:\data\SAS\DATA_LOAD\xyz.TXT' WITH ( FORMATFILE = 'H:\data\SAS\DATA_LOAD\\xyz.FMT', DATAFILETYPE='CHAR', ROWS_PER_BATCH=100, TABLOCK, ERRORFILE='H:\data\SAS\DATA_LOAD\\xyz_ERROR.LOG' )But I am getting the following errorCannot bulk load because the file "H:\data\SAS\DATA_LOAD\XYZ.TXT" could not be opened. Operating system error code 3(error not found).Can you please help me to resolve this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 00:57:09
|
| do you have specified file in location of server? Are you sure you're using right path? |
 |
|
|
devisetti
Starting Member
30 Posts |
Posted - 2008-10-08 : 01:02:37
|
| yes , I am using the right path.Is it with access rights problem. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 01:15:02
|
quote:
Originally posted by devisetti
yes , I am using the right path.Is it with access rights problem.
is the file in server itself? in that case it can be access right probelm. see if folder can be accesed. Also check if you dont have kept the file opened. |
|
|
|
|
|
|
Bulk insert problem