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........1You don't mention your results with DTS. Was there a problem?