June 4, 2008 at 5:47 pm
Hi,
Thanks for your advice!
I have a Sql acct and my user wants to create SSIS packages.
What permissions do I need to give to that SQL acct, so he can create SSIS packages.
Thanks again.
June 5, 2008 at 4:02 am
SSIS packages are created in BIDS, so the permissions you should be considering is one of the following:
a) Your user will be loading data to tables, so in the development SQL environment, provide him with the required access to do his work.
I am always adament that development belongs to developers. Let them go mad there, and usually provide them with sysadmin
b) When the user migrates the package to another environment, he will most probably be running this from a job scheduler.
Make sure that your SQL server agent account has sufficient rights to the relevant databases/file stores
c) If your developer starts using package configurations, either make sure that you have file storage for the xml configuration files, or a dedicated SSIS Configurations database. Once more, when it is placed onto a different environment, your agent will require access to this.
d) Read up on environment variables. In all likelihood you will need one explaining to SQL where the configurations are located.
Good luck
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply