How to execute SSIS package from stored procedure? At this moment I am able to do this by using Windows authentication. However, I must do it using SQL Server authentication, but SQL Server requires Windows authenticated user.
Sql-server – SSIS – executing package from SQL Server by stored procedure
sql serverssis
Related Question
- Sql-server – Run an SSIS package located on a linked server from a stored procedure
- Sql-server – Executing SSIS catalogue package from a different machine, authentication fail
- Sql-server – The operation cannot be started by an account that uses SQL Server Authentication. SSIS Package
- Sql-server – Find SSIS package which calls stored procedure
- Sql-server – SSIS job — how to create stored procedure that repeats SSIS jobs
- Sql-server – Execute SSIS procedure from stored procedure using non-privileged SQL login
- Sql-server – Unable to deploy SSIS package to remote sql server
Best Answer
If you are using SSISDB (which I think you are?), you can Execute a set of standard stored procedures that are in the SSISDB. These are outlined in the MSDN Article here.
This article also states the permissions that are required to run these procedures. It sounds like you need to set up a SQL Server login which has these permissions. How to describe this is located here. You will need to do this with your existing Windows Authenticated user if it has permission to allocate permissions (ALTER ANY LOGIN or ALTER LOGIN permissions).
You may also need to create a user who is mapped to this login as described here.
Your question is not very specific so without further information about a particular problem you are having, it is difficult to give a clear answer.