Skip to main content
February 12, 2009
Question

Getting multiple file from FTP and inserting file conten to DB

  • February 12, 2009
  • 1 reply
  • 413 views
Hello,

i need to get file from FTP and insert file content to SQL DB. What process i need to follow?

I am able to connect to FTP server and list files using following code...

Questions:
1. Do i need to get file from FTP and store in local folder to read file and insert to DB?
Or i can read file directly from FTP and store to DB?.

2. What kind of loop i use for reading muliple files from ftp?

Please help me with steps to follow for reading file content..

    This topic has been closed for replies.

    1 reply

    Inspiring
    February 13, 2009
    1. You can read files from anywhere on your server.
    2. Loop through query to get you started.
    February 13, 2009
    1. You can read files from anywhere on your server.

    You mean, i can read file from FTP? Parse file content and insert to DB?
    No need to move file from FTP CF server and then read content?