Loading data using bcp

• alex finch

  SSC Journeyman

  Points: 87

  More actions

  January 5, 2007 at 4:06 pm

  #175444

  I am trying to load data from a csv style doc but I only get the message "0 rows copied."  There is one row of data and when I do the insert statement below, it successfully inserts.  Anyone know what is going on?  Here a sample of the the data:

  PERSON_INFO_IDÑKEYÑAUTH_IDÑSEQUENCE_NOÑREPORT_TYPEÑREPORT_TRANSMISSION_CODEÑID_CODE_QUALIFIERÑID_CODEÑDESCRIPTIONÑFILE_NAMEÑMIME_TYPEÑFILE_SIZEÑENTRY_USERÑENTRY_DATEÑUPDATE_USERÑUPDATE_DATEÑDELETED

  1ÑÑ1ÑÑ59ÑVOÑÑÑÑÑÑÑ1Ñ1/1/2004Ñ1Ñ1/1/2004ÑN

  I run this line:

  bcp BASE_DEV_R65_03.dbo.PERSON_INFO in ..\Load\PERSON_INFO.csv -o..\Load\csv_out\PERSON_INFO.log -e..\Load\csv_err\PERSON_INFO_err.log -F2 -UUSER -PPASSWORD -SSERVER -m999 -c -t"Ñ" -r"\n"

  But it works if I use this insert with the same data:

  insert

  into PERSON_INFO (PERSON_INFO_ID,KEY,AUTH_ID,SEQUENCE_NO,REPORT_TYPE,REPORT_TRANSMISSION_CODE,ID_CODE_QUALIFIER,ID_CODE,DESCRIPTION,FILE_NAME,MIME_TYPE,FILE_SIZE,ENTRY_USER,ENTRY_DATE,UPDATE_USER,UPDATE_DATE,DELETED)

  values

  ('1',null,'1',null,'59','VO',null,null,null,null,null,null,'1','1/1/2004','1','1/1/2004','N')

  Any help is appreciated!

• jezemine

  SSCrazy Eights

  Points: 8109

  More actions

  January 6, 2007 at 11:28 pm

  #681664

  try specifying -r"\r" instead of -r"\n". I am guessing that your lines are separated by carraige return/line feed instead of newlines.

  see http://msdn2.microsoft.com/en-us/library/ms191485.aspx for details on the -r flag.

  ---------------------------------------
  elsasoft.org