All geek questions in one place

Running SSIS packages remotely - on which account do they work?

I am currently creating an application in .NET 4.0 that will use SSIS 2008R2 packages to do its job. Packages are located on a separate SQL Server. The SQL server has an account proxy that has all the permissions necessary to execute the packages (calling report services, accessing the disk, etc.).

My question is: what is the best way to run these packages from C #?

I read about using SQL Agent to run packages through workstations, but I'm worried about this: in which account will jobs and packages work? Will it be the account on which the application is running, or can I use the proxy account that I have in SQL Server? How can I customize this?

Thanks in advance!

+4
source share
1 answer

You can configure the user to perform each step of the job in the SQL Server Agent. Usually a proxy server is used here.

An easy way to start a task if you need access to the SQL Server database in any case is to call SQL Server Agent stored procedures . But note that running a job through dbo.sp_start_job is asynchronous: it just starts the job and then returns. You will need to interview other methods to check the status of the job or the result.

And the database user that you use to connect to the database (or your local user if you use the built-in login in SQL Server) must have permission to call the stored procedure.

+1
source

Source: https://habr.com/ru/post/1498576/

More articles:


All Articles