September 8, 2009 at 3:13 am
Within my organization a department have a need to create SSIS packages, the problem being, we want them to be able to run the SSIS packages but not have access to change the database structure. Can SSIS be installed on a client machine only and not install SQL server 2005 on their PC.
September 8, 2009 at 11:32 am
clucasi (9/8/2009)
Within my organization a department have a need to create SSIS packages, the problem being, we want them to be able to run the SSIS packages but not have access to change the database structure. Can SSIS be installed on a client machine only and not install SQL server 2005 on their PC.
depends on what you want, do you want them to be able to run them only, or to design/create them as well. if they are to create them, then they will need rights to the data anyways. you can always restrict rights so they cannot change database structure/schema. Unless they have copies of the data on the client machine, the SSIS packages I would imagine would be accessing data on a server.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 11:01 am
SSIS can be installed without the SQL Engine, but as the previous poster alluded to,they will need access to some data. Another options is a virtual machine with all the tools and a dev copy of the DB (possibly with rights locked down) that the developers could remote into and work off of. This works well in many environments where folks don't want to install tools on a lot of machines. Citrix is also a good option, but I have seen performance issues with painting the screen for dev tools and this is REALLY aggravating :).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply