View Poll Results: Download the data from ftpserver to sqlserver

Voters
0. You may not vote on this poll
  • sqlserver bcp

    0 0%
  • sqlserver dts

    0 0%
  • java

    0 0%
Multiple Choice Poll.
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Unhappy Unanswered: 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.mattmccoy.com//AB20031021.txt
    File AB20031021.txt is Downloading
    File AB20031021.txt downloaded
    Connecting to ftp://mednewd:med1010newd@ftp.mattmccoy.com//AV20031021.txt
    File AV20031021.txt is Downloading
    File AV20031021.txt downloaded
    Connecting to ftp://mednewd:med1010newd@ftp.mattmccoy.com//CA20031021.txt
    File CA20031021.txt is Downloading
    File CA20031021.txt downloaded
    Connecting to ftp://mednewd:med1010newd@ftp.mattmccoy.com//BIB20031021.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 is..........1
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    You don't mention your results with DTS. Was there a problem?
    -bpd

Posting Permissions

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