Scheduling the SSIS
-
Monday, February 04, 2013 8:52 AM
Hi,
Scenario 1 :- could you please suggest me that what kind of the rights to be provided for scheduling the ssis using the proxy/client.
Scenario 2 :- I have SSIS integration server in my system, also I am using sql server agent to schedule the job by connecting the remote database, suggest me then what kind of rights to be provided to do the same.
Please help me out, Thanks in advance.
Rajan
All Replies
-
Monday, February 04, 2013 9:40 AM
If you want to use SQL Server Agent für Sceduling a SSIS Package you need the right to greate a SQL Server Agent Job.
Take a look here: http://msdn.microsoft.com/en-us/library/ms188283.aspx
If you want to upload your Package to SQL Server for executing you need one of the following roles: http://technet.microsoft.com/en-us/library/ms141053.aspx
To connect a remote database in SSIS, sceduled or not, you need no other rights than the same you need if you do this from commandline/Management Studio.
But remember: it you scedule your package than the user the Agent you runs your package under, needs the right for the remote Database. Execept you encrpyt the remote rights in the package itself (http://technet.microsoft.com/en-us/library/ms141747.aspx)
Hote it helps
selcer
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 11, 2013 6:57 AM
-
Thursday, February 07, 2013 12:59 PMModerator
It depends.... what does your package do? Any source files? What kind of database access are you using?
Easiest is probably to create a Windows user that has rights to the database (if you're using integrated security to access your database) and it should have enough rights in the folders where sources files are located.
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 11, 2013 6:57 AM
.png)
