We've been using DTS under SQL Server 2000 for some time to perform a very
simple database export once a day to another SQL Server. The process of
setting that up was using the Import/Export wizard, checking all the tables
and then ticking the box saying the DTS job should be scheduled to run once
a day. Nice and simple. Luvly jubly.

Now we've moved over to SQL 2005, creating an equivalent job seems to be
incredibly difficult. There are no scheduling options when using the Export
data wizard. The Copy Database wizard demands that I specify a sysadmin
password for both servers, which - to be honest - I don't want to do; and
when the scheduling options are used there, it creates a pull job on the
remote server instead of a push job on the master.

I'm probably being dense here, or just lazy, but where's the nice easy
equivalent in SSIS of the scheduled DTS we used to use?

Thanks for any advice!

Chris.