Getting multiple file from FTP and inserting file conten to DB

[Guest]

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..

[Dan_Bracuk]

1. You can read files from anywhere on your server.
2. Loop through query to get you started.

[Guest]

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?