>Hi,
>
>I have a SQL Server Express 2008 R2 database from which a third party needs to extract some data on a nightly basis. The third party wants the data put into another database overwriting all the data that was there previously. My database sits on my client's server and the other database is on another server completely unconnected to the first one. The only way to transfer the data is via ftp (or email, I guess).
>
>How would you suggest I approach this?
>
>Do I write a Stored Procedure which extracts the data and puts it into a separate database, then disconnect the database and ftp the database files? Can Stored Procedures do ftp? Maybe I need to write a Powershell script to do this?
>
>Any ideas welcome!


Hi Frank,

You can use a FTP task in SQL Server Integration Services

[Update]
I just realized you said SQL Server Express, not sure if SSIS is available for it, sorry for misleading you if that is the case.