SSIS "Install" Question

  • We want each computer in our training lab to have access to SSIS. Do we have to install the full SSIS package on each computer or is there a client tool that would allow the computers to access the SSIS install on our Development server?

    TIA,

    barkingdog

  • The cheap solution to your situation is to either use trials at all those locations good for 6 months or the developer edition under $50 online. The reason is you can develop without an SSIS instance but you need an instance to execute the code, you must also be aware that most ETL task it is better to use the Enterprise edition. I almost forgot SSIS runs as a service in any Windows Server so all SQL Server instances uses the same instance.

    http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2999/

    Kind regards,
    Gift Peddie

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

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