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

    Unhappy Unanswered: BCP and DTS Problem!!!Error!!!Help me immediately

    Hi experts,


    I tried to download a file from ftpserver to sqlserver.I properly downloaded one text file(AB20031006.txt,ABDATA table has 4fields and 13843 records) with bcp but I could not do with other text file(BIB20031006.txt,BIBDATA table has 52 fields and 73000 records).


    my bcp command is:
    C:\MSSQL7\Binn>
    bcp master..BIBDATA in c:\idocfile\new\BIB20031006.TXT -fc:\MSSQL7\Binn\bib52.fmt -SJAVADEV2-PC -Usa -P

    I failed in DTS
    After selecting the text file,I checked delimited check box then I clicked on next button I'm getting error like Error:Row Delimiter not found.
    filtype: ANSI SKIP ROWS 0
    ROW DELIMITER:{CR}{LF} FIRST ROW HAS COLUMN NAMES(CHECKED)
    TEXT QUALIFIER:NONE


    Why this is happening.It would be appreciated if anyone can solve this pb.

    Thanks
    ven
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2001
    Posts
    2

    Post

    did you specify while doing the DTS, to exclude 1st row?
    -Vallabhai

Posting Permissions

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