Executing SSIS Package with SQL Authentication
I don't think you can execute this using an SQL Server authentication, you will receive the following exception:
The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication
There are many workaround that you can do, check the following links:
- The operation cannot be started by an account that uses SQL Server Authentication. SSIS Package
- Issues with module signing and SSIS catalog internal procedures
How can I use SQL Server Authentication for SSIS Packages Deployment using a Catalog?
SQL Server Authentication is not supported for the Project Deployment model.
There is no hack, no workaround - a windows account must be authenticated to SQL Server and authorized to do the deploy.
Related Topics
Limit Ignored in Query with Group_Concat
How to Perform the Same Aggregation on Every Column, Without Listing the Columns
Get Envelope.I.E Overlapping Time Spans
Sqlite Equivalent of Postgresql's Greatest Function
Create Users Dynamic Names and Assgin Roles
Creating a Flattened Table/View of a Hierarchically-Defined Set of Data
How to Convert "2019-11-02T20:18:00Z" to Timestamp in Hql
How to Determine the Auto-Generated Primary Key Used as a Foreign Key for Another Table
How to Remove Certain Results from My Search Count
Oracle - Literal Does Not Match Format String Error
Doctrine Query - Ignoring Spaces
F# Type Provider for SQL in a Class
This SQL 'Order By' Is Not Working Properly
Different Ways to Alias a Column
How to Use Ado Query Parameters to Specify Table and Field Names