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

    Unanswered: Urgent!!! download the data from ftp to sqlserver(anyway,bcp,dts,java or vb and asp)

    Download the data from ftpserver to sqlserver
    Hi,

    It would be appreciated if anyone can solve my problem.

    hwz going ur end .its a new assignment .i've to get data from ftpserver and download the into sqlserver.

    I tried in 3ways .
    1)With bcp command
    C:\MSSQL7\Binn>
    bcp master..BIBDATA in c:\BIB20031006.TXT -fc:\MSSQL7\Binn\bib52.fmt -SJAVADEV2-PC-NJ -Usa -P
    2)dts (data tranformation services)
    3)with java pg

    I tried with bcp command i downloaded 14000 records in a table ABDATA(It has 4 fields only) but I couldn't download properly with
    BIBDATA(It has 52 fields).It has 70000 records.I'm able to download only 155 records.That is the pb.


    here i'm sending java files too.can u pls try locally in ur machine and give me reply immediately.

    C:\java MyMainFTP
    Connecting to ftp://mednewd:med1010newd@ftp.mattmc...AB20031021.txt
    File AB20031021.txt is Downloading
    File AB20031021.txt downloaded
    Connecting to ftp://mednewd:med1010newd@ftp.mattmc...AV20031021.txt
    File AV20031021.txt is Downloading
    File AV20031021.txt downloaded
    Connecting to ftp://mednewd:med1010newd@ftp.mattmc...CA20031021.txt
    File CA20031021.txt is Downloading
    File CA20031021.txt downloaded
    Connecting to ftp://mednewd:med1010newd@ftp.mattmc...IB20031021.txt
    File BIB20031021.txt is Downloading
    File BIB20031021.txt downloaded
    I am going to read next line ,Line Number is..........0
    iCount........1 Number of Tokens :79
    java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]The name '
    BD' is not permitted in this context. Only constants, expressions, or variables
    allowed here. Column names are not permitted.
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc .java:6958)
    at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :7115)
    at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :3111)
    at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcSt atement.java:338)
    at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcO dbcStatement.java:2
    53)
    at MyMainFTP.insertToDatabase(MyMainFTP.java:264)
    at MyMainFTP.main(MyMainFTP.java:121)
    I am going to read next line ,Line Number


    YPE ISBN AUTHOR1 LAST NAME AUTHOR1 FIRST NAME AUTHOR1 MI AUTHOR1 SUFFIX AUTHOR2 LAST NAME AUTHOR2 FIRST NAME AUTHOR2 MI AUTHOR2 SUFFIX TITLE EDITION VOLUME SERIES TITLE ISSN COPYRIGHT DATE PUBLICATION DATE BINDING CODE BINDING NAME SUBJECT CAT SUBJECT CLASS NET PRICE LIST PRICE NYP PRICE PREPUB PRICE PREPUB EXP DATE PUBLISHER CODE PUBLISHER NAME VENDOR CODE VENDOR NAME REMARKS REMARKS TRANS REMARKS LAST CHG DATE NEW EDITION ISBN SUBJECT DEFINITION NLM LC WEIGHT NUMBER OF PAGES LANGUAGE FORMAT DISCOUNT CODE BRANDON HILL NON-RET CODE PRICE INCREASES PRICE INCREASE DATES PUBLISHED CODE IMAGE FILE NAME QUANTITY AVAILABLE INACTIVATE FLAG ACRONYM ACRONYM TRANSLATION
    BD 0803609647 Bonder Bette R. Functional Performance in Older Adults 01 1994 0594 C Hardcover ME GER 47.00 008036 Davis, F.A. 008036 Davis, F.A. NE AVL RD 10/20/00 A New Edition is Available 05/29/96 0803605439 AGING-PHYSIOLOGY; AGED-PSYCHOLOGY WT 104 QP86 2.07 398 English 1 42.00|45.00 05/01/97|04/07/00 0803609647.gif 0
    BD 0721629164 Butterworth John F. Atlas of Procedures in Anesthesia and Critical Care 01 1992 0192 C Hardcover ME ANS 45.00 007216 Saunders, W. B. 007216 Saunders, W. B. OP RD 05/01/01 This Title is Out of Print 03/28/01 ANESTHESIA-METHODS-ATLASES WO 517 RD81 1.93 239 English T 37.50|39.00|41.00|43.00 01/01/97|11/04/97|11/02/98|11/01/99 0721629164.jpg 0
    BD 0892814977 Jones Kenneth Pau d'Arco: Immune Power from the Rain Forest 01 2000 P Softcover AM A-M 8.95 089281 Inner Traditions International 089281 Inner Traditions International English 1 NR180 P 0
    BD 0412391600 Reed G.B. Diseases of the Fetus and Newborn: Pathology, Imaging, Genetics and Management 02 2VLS Diseases of the Fetus and Newborn: Pathology, Imaging... 9999-8504 1995 0295 C Hardcover ME PED 225.00 000412 Chapman & Hall 000397 Lippincott Williams & Wilkins OP This Title is Out of Print 01/20/95 FETAL DISEASES; NEONATAL DISEASES & ABNORMAL WQ 211 RG629 7.21 1590 English 2 295.00|310.95 01/12/96|02/04/99 0
    Attached Files Attached Files

Posting Permissions

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