SQL Server Performance

schedule

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 20, 2007.

  1. fmardani New Member

    How is it possible to schedule a SSIS package to run at a certain time please?
  2. ranjitjain New Member

    In 2005, connect to SSMS and the connect to sql server db engine.
    Expand SQL server agent and click on create new job.
    Under this new job create new job step with type as SQL server Integration package.
    Then specify package name and location and config file if any.
    After this create new schedule to run the job at your desired time.

Share This Page