Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IainC
Starting Member
3 Posts |
 Posted - 2009-09-08 : 02:53:03
|
| Within my organisation 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. |
|
|
toddbkc
Starting Member
9 Posts |
Posted - 2009-09-08 : 11:50:40
|
| Yes, you can simply perform the "Client Tools" installation of SQL Server on each computer you want to create SSIS packages on. They can then point the Data Sources to whatever SQL Server you want. As long as their login (or a SQL login for the Data Source) has appropriate permissions to the database and tables (DataReader or DataWriter for insert/update) you should be in complete control without them having the ability to alter the tables.TODD |
 |
|
|
|
|
|
BIDS / SSIS Installation