probably my explanation was not clear enough. We have a FTP client that downloads the files from a distant webserver. How can I tell in SQL Server that the client is ready with its download?
Another question: is it possible to perform the download (from a FTP server) with the SQL server itself and without a FTP client?
what resolution? If you mean the solution, then yes I did. I used the xp_fileexist (without the -s at the end) and created a job that calls a stored procedure that imports the text into a table (bulk insert) and then copies the data to several tables.