Post reply

SSIS File Deployment

  • May 28, 2009 at 6:54 am

    #155756

    If we deploy the SSIS package on our web server using file system deployment, what all needs to be installed on that server so that we can call and execute that package from ASP.Net ? Will that folder need to be shared or something like that ?

  • May 28, 2009 at 8:52 am

    #1001476

    anjali.vishwakarma (5/28/2009)

    If we deploy the SSIS package on our web server using file system deployment, what all needs to be installed on that server so that we can call and execute that package from ASP.Net ? Will that folder need to be shared or something like that ?

    The machine executing the package should have the SSIS framework installed.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • May 31, 2009 at 10:13 pm

    #1002549

    Thanks Cozyroc.

    By SSIS Framework you mean Integration Services. Right ?

    Also what about the sharing part ? Do we need to set some sharing rights on the folder storing the package ?

  • May 31, 2009 at 10:49 pm

    #1002556

    Also the system I am going to deploy my package will not have SQL server installed in it. It will be just a web server. Integration Services is a part of SQL Server. So can we have just Integration Services installed on the system and not the complete SQL Server ?

  • June 1, 2009 at 4:28 am

    #1002635

    anjali.vishwakarma (5/31/2009)

    Thanks Cozyroc.

    By SSIS Framework you mean Integration Services. Right ?

    Also what about the sharing part ? Do we need to set some sharing rights on the folder storing the package ?

    Yes, correct - " Integration Services". And yes you have to provide rights to the network share holding your SSIS package.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 1, 2009 at 4:29 am

    #1002636

    anjali.vishwakarma (5/31/2009)

    Also the system I am going to deploy my package will not have SQL server installed in it. It will be just a web server. Integration Services is a part of SQL Server. So can we have just Integration Services installed on the system and not the complete SQL Server ?

    Yes, you can install only "Integration Services". However keep in mind you have to still purchase complete "SQL Server" license, to be able to use only "Integration Services".

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 1, 2009 at 6:28 am

    #1002697

    Thanks Cozyroc once again !!

    One more small query - what rights do we need to set on folder storing the package ?

  • June 1, 2009 at 7:02 am

    #1002721

    anjali.vishwakarma (6/1/2009)

    Thanks Cozyroc once again !!

    One more small query - what rights do we need to set on folder storing the package ?

    I think reading should be enough because the share serves only as storage.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 1, 2009 at 7:09 am

    #1002729

    Thanks Cozyroc !!

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

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