Target File
The name and location of the file to be generated by the action. Usually this is in the dacpac format.
Source Type
Whether to use a connection string or specify each part of the connection separately.
Source 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;
Source Database Name
The name of the database connecting to.
Source Server Name
The name of the server that hosts the database. The server should be accessible by the agent running the action.
Source User
The name of the user who has permissions to perform the operation on the database.
Source 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.