george sibbald (6/30/2010)

---

right click database

tasks

export data

at the end choose to save it as a SSIS package

then you can schedule that package via SQLAgent

Is this not the way you did it...

Hmm, nope can't find any copy table wizard. I'll play around with trying to schedule an import/export package.

Alright bear with me here. I've found the database copy utility, but doesn't let me specify an individual table.

I've been able to save the package when doing a...