Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Unanswered: BCP problem.Pls solve anyone immediately

    Hi all,

    I tried with that but i am able to inserting abtable(this has 4 cols and 12000 records) with bcp.that is working very good.but i'm getting problem with other table bibtable(this has 52 cols and 73000 records) with bcp but it is inserting all rows with dts.i want to insert both of the tables either of one bcp or dts to insert data into sqlserver 7.0


    my bcp commands are:
    bcp master..BIBDATA in c:\BIB20031006.TXT -fc:\MSSQL7\Binn\bib52.fmt -SJAVADEV2-PC-NJ -Usa -P
    this is working properly with abtable but not with bibtable

    bcp master..bibdata in c:\medsite\idocfile\new\bib20031006.txt -c -F2 -t\t -r\n -e c:\mssql7\binn\bib52.fmt -SJAVADEV2-PC-NJ -Usa -P
    this is not working with anyone

    in dts:


    .delimited
    filetype:ANSI SKIP ROWS:0
    ROW DELIMITER:LF FIRST ROW HAS COLNAMES CHECKED
    TEXT QUALIFIER:''

    this is inserting bibtable perfectly but not abtable(inserting few records only)

  2. #2
    Join Date
    May 2003
    Posts
    60
    Try removing the space after the -e in the string -e c:\mssql7\binn\bib52.fmt so it looks like -ec:\mssql7\binn\bib52.fmt and put spaces in this string -SJAVADEV2-PC-NJ so it looks like -SJAVADEV2 -PC -NJ

  3. #3
    Join Date
    May 2003
    Posts
    60
    Try removing the -F2, this is telling the bcp utility to only copy the first two rows.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •