Bulk Copy Error Log Problem

• Cory Slaney

  SSCrazy

  Points: 2459

  More actions

  September 8, 2005 at 9:01 am

  #94877

  I use the following script in a batch file to perform a bulk copy:

  for /r G:\FTPServer\ADAM6Upload\Mission %%i in (*.flt) do bcp sis2_dfo..t_flt in %%i /f  c:\MakeXML\post_scripts\flt.fmt /U sa /P ou812

  and recently added the code /E C:\MakeXML\errorlog.err

  However, when I tried to run the batch file again containing the resulting code:

  for /r G:\FTPServer\ADAM6Upload\Mission %%i in (*.flt) do bcp sis2_dfo..t_flt in %%i /f  c:\MakeXML\post_scripts\flt.fmt /U sa /P ou812 /E C:\MakeXML\errorlog.err

  the bulk copy would not work. Then I removed the code /E C:\MakeXML\errorlog.err and the batch file and bulk copy worked fine again.

  What could the problem be? I used the MSDN Library which stated that I could use the /E switch to ouput bulk copy errors to a logifile (C:\MakeXML\errorlog.err). Is there something I am doing incorrectly with the syntax?

  The database and code is running on Windows Server 2003 Standard SP1, SQL Server 2000 with SP4.

  Any help would be greatly appreciated!

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  September 8, 2005 at 9:58 am

  #588440

  Try a lower case 'e'.

  ---

  And then again, I might be wrong ...
  David Webb

• noeld

  SSC Guru

  Points: 96590

  More actions

  September 8, 2005 at 10:13 am

  #588452

  Just to clarify a bit David's Answer:

  /E means use Windows Integrated authentication

  /e means specify error log file path

  you are already using sql authentication

   

  Cheers

  
  * Noel