I am a relative newbie to SQL Server 2005. I have gone through the process of migrating my packages to 2005. My question is this. How do I schedule the package to execute at a specific time through SQL Server 2005?

Dont you have somthing called scheduling in SQL 2k5. Personally, i havent been able to play arnd with sql 2k5, but in sql 2k, there's scheduling jobs. I am sure the same/better, must be in sql 2k5.

Check books online or something.

cheers

NOthing is impossible if you dare to.

Since you have migrated your packages it is safe to say that they are then SSIS packages and they are stored in the SQL Server.
Create a job, Create a new job step. Select SQL Server Integration Services package execution as the job step type.
For more info see 2005 BOL topic: How to: Run a Package Using a SQL Server Agent Job

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Alternatively you can create a job step of type Operating System (cmdExec) use the dtexec command line tool

If it is a DTS (SQL 2000) Package then you can create a job step of type Operating System (cmdExec) and then use the dtsrun.exe command line tool (see SQL 2000 BOL for info about its parameters)

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Use Job steps in SQL Management Studio to schedule a SSIS package. Also make sure that SSIS service is installed and running otherwise you will get an error.

Bader Cheema