How can a user with READ only Execute an SSIS package that has a WRITE dataflow task?
Hi, Using Visual Studio 2010 and Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1). I have created an SSIS package that runs loads data from Excel to 3 tables in a database. I have write permissions on this database. I am handing this package over to other users. The package is located on a shared space and can be executed by someone with similar permissions to me. However, many users have only read access to this database. Is there a way they can also execute the package? Many thanks, Quentin
@JohnM - I haven't deployed yet to a user with less privileges. Only to someone with similar. And they opened the package and ran it. I envisioned something similar for the user with less privileges. When you say SSIS would consume the data and feed the data into a procedure...do you have an example of what you mean? I have used SSIS to load to staging and executed stored procs against those before. Regards, Q