Interested to Buy Any Domain ? << Click Here >> for more details...
How can a procedure fetch data from FTP?
I need a general code for this..
- 1 Answers
- 1366 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / Iqra
To fetch data from FTP using a SQL Server stored procedure, you can use the OPENQUERY function. Here's an example of a simple stored procedure:
```sql
CREATE PROCEDURE dbo.GetDataFromFTP
AS
BEGIN
DECLARE @SQL NVARCHAR(MAX)
SET @SQL = 'SELECT * FROM OPENQUERY(FTP, ''SELECT * FROM file.txt'')'
EXEC (@SQL)
END
```
This procedure assumes you have a connection to an FTP server named 'file' and the data is stored in a text file named 'txt'.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
