View Poll Results: Download the data from ftpserver to sqlserver
- 0. You may not vote on this poll
10-21-03, 16:46 #1Registered User
- Join Date
- Oct 2003
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.
Connecting to ftp://mednewd:firstname.lastname@example.org//AB20031021.txt
File AB20031021.txt is Downloading
File AB20031021.txt downloaded
Connecting to ftp://mednewd:email@example.com//AV20031021.txt
File AV20031021.txt is Downloading
File AV20031021.txt downloaded
Connecting to ftp://mednewd:firstname.lastname@example.org//CA20031021.txt
File CA20031021.txt is Downloading
File CA20031021.txt downloaded
Connecting to ftp://mednewd:email@example.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
I am going to read next line ,Line Number is..........1
10-21-03, 17:02 #2Registered User
- Join Date
- Aug 2003
- Andover, MA
You don't mention your results with DTS. Was there a problem?-bpd