i have written a store proc to perform to do a backup zip and ftp process..

my question is i have to run this store proc from ssis for sql 2000...

I have all script ready to do a backup, zip and FTP but only concern is can i run a backup script from ssis for sql 2000 db?????

which utility will help me to perfom sql 2000 backup zip and ftp from ssis .. please advice...

No you get me wrong... let me tell you more clearly.

I have one db in sql 2008 but we need to send same to db to client as sql 2000,...

I do want to do a restore, I just want to take a backup of sql 2000 db from sql 2008 server....then will do a zip and put on http://FTP...