View Poll Results: Download the data from ftpserver to sqlserver

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

    Unhappy Unanswered: Download the data from ftpserver to sqlserver


    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
    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
    File AB20031021.txt is Downloading
    File AB20031021.txt downloaded
    Connecting to
    File AV20031021.txt is Downloading
    File AV20031021.txt downloaded
    Connecting to
    File CA20031021.txt is Downloading
    File CA20031021.txt downloaded
    Connecting to
    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( :7115)
    at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect( :3111)
    at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcSt
    at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcO
    at MyMainFTP.insertToDatabase(
    at MyMainFTP.main(
    I am going to read next line ,Line Number is..........1
    Attached Files Attached Files

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

Posting Permissions

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