Post reply

Installing SSIS on a server other than the database server.

  • March 9, 2009 at 4:06 am

    #155389

    Hi,

    I have to run SSIS packages on a server which isn't a database server, and the SSIS package needs to launch a process on this application server. Moreover the package needs to be launched by a SQL Job (which calls DTExec).

    So I figure I need SQL Agent and SSIS on the application server. Can these be installed without installing SQL Server? And if so, will the license (i.e. cost) be the same as if I installed the full suite?

    Thanks for your help,

    David McKinney.

  • March 9, 2009 at 7:34 am

    #955974

    David,

    You do need SQL Server installed to run the SQL Server agent. Although you can install SSIS without SQL Server, it's generally not worth doing so. You'll still require a SQL Server license when you install only SSIS, and you lose the benefit of having the SQL Server Agent to schedule the execution of packages.

    hth,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

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

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