Post reply

Is SSIS needed to run an SSIS package?

  • December 23, 2008 at 9:40 am

    #125298

    Hi,

    This may sound silly... but I remember doing something like this once before, but since its been very long I wanted to check with you guys.

    If I develop an SSIS package on DEV server and generate the 'build', would I be able to run the package on PROD server that does not have SSIS installed? I guess, once you generate a 'build', its all binary and could be executed from command prompt.

    Its a simple package, lets say, and assume that login details are not a problem. If it is possible, could I use the SSIS deployment utility to deploy this in PROD? or do I need SSIS installed in PROD as well?

    Any help would be great,

    _UB

    SqlTimes Blog on Sql Server

  • December 23, 2008 at 11:14 am

    #916942

    SSIS Packages will only run on an SSIS Server of the appropriate edition. Some basic transformations are available on a SQL Server without SSIS installed. These are the ones needed for the extract wizards and maintenance plans. For anything else, you need to install the edition of SSIS that includes the components in your package.

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

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