I'm a complete newbie to SSIS -- I would like to "automate" the Copy
Database Wizard (so that I don't have to enter the source/destination each
time -- and so that I can also schedule the operation).

Could someone provide some pointers on how to do this, either using SSIS?
(Or, do you recommend just using scripts - sp_detatch / attach? If the
latter, does anyone of those scripts handy?)

Thank you for the help!

Raymond

Hello Ray,

Personally i do use BACKUP and RESTORE. You cannot automate the wizard but
what you can do is configure the task in a package and then schedule the
package using SQL Server Agent.

Is the task going to change?

Allan

I think I found the answer - using SSIS Transfer Database Task. The only
thing is, that task requires me to create a network share to the directory
where the mdf files are located.
Ray

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote