interaction Stored Procedure - FTP-server

hi all,

this is my question:

can a stored procedure interact with a FTP-server that has nothing to do with the database the stored procedure is running from?

I want my stored procedure to delete records in my database AND my FTP-server in the same time..., so also uploaded files which have been uploaded to a FTP-server during the same session when data has been written to my database...?

this is my SP for deleting records in my database:

...

DELETE FROM dbo.tblUploadsIntern WHERE DATEDIFF(dd,GETDATE(), tblUploadsIntern.uplZipfileDateTimeOffline) > 7

END

GO

the code for deleting files on FTP-server works also...

thanks in advance...

I would not load my SQL Server with housekeeping like this.

However, you could create a SQL Agent Job that would take care of this for you.

But, really, if it has nothing to do with SQL Server, why not make a Windows Scheduler Job to do the clean up?