SQL Package Publish
Target
Connection String
Connection Properties
Variables
Properties
Options
Environment
Source File
The name and location of the file to be consumed by the action. Usually this is in the dacpac format.
Target Type
Whether to use a connection string or specify each part of the connection separately.
Target Connection String
The SQL Server/Azure connection string to connect to the database. An example of a valid connection string is:
Provider=SQLNCLI11;Password=myPassword;User ID=[username]@[servername];Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;
Target Database Name
The name of the database connecting to.
Target Server Name
The name of the server that hosts the database. The server should be accessible by the agent running the action.
Target User
The name of the user who has permissions to perform the operation on the database.
Target Password
The password for the user connecting to the database.
Additional Arguments
The extra arguments and properties to set for the sqlPackage call. The full list of extra arguments and properties can be found at SqlPackage.exe.
Overwrite Files
Whether the action should overwrite the file it is generating.
Quiet Logging
Whether the logging should be limited to completion messages or not.