Post reply

Scheduling package in sql server 2008 r2 express edition

  • December 4, 2013 at 3:37 am

    #287093

    Hi,

    I have created a package in ssis and i need to schedule it every week. How do i do that since i found out that there is no sql server agent in 2008r2 express edition.

    Please help.

  • December 4, 2013 at 3:47 am

    #1670649

    suchitra.venkataramani (12/4/2013)

    Hi,

    I have created a package in ssis and i need to schedule it every week. How do i do that since i found out that there is no sql server agent in 2008r2 express edition.

    Please help.

    My understanding is that you'll need to install Integration Services to be able to do this - and that Integration Services is not part of SQL Server Express (except in skeleton form to support the Import/Export Wizard).

    So I don't think you'll be able to do this.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 11, 2013 at 11:41 pm

    #1672830

    You should not have SQL Agent for SQL Express edition, so you should not create a job and schedule..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply