Need help on creating SSIS package for Nightly Backup and Restores of Database

We had a couple of database in production server. need to restore it on Staging every night for reporting pu开发者_开发问答rpose. I want to know whether I can creat a SSIS package for that.

Thanks,

karthik

Yes you can do that.

Take a look at this article that goes over creating or refreshing a reporting database.

If you have a more detailed question please post it.

Use "Transfer Database Task" I think it is much faster than backup/restore