...
The SQL Package Script action creates a Transact-SQL incremental update script that updates the schema of a target database to match the schema of a source database.
SQL package Script
Name
A friendly name for this action (will be displayed in the actions workflow area).
...
Whether to use a connection string, a target file or specify each part of the connection separately.
Connection String
Connection String
...
Provider=SQLNCLI11;Password=myPassword;User ID=[username]@[servername];Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;
Connection Properties
Server Name
The name of the server that hosts the database. The server should be accessible by the agent running the action. [/TargetServerName]
...
The timeout for establishing a connection to the database in seconds. Leave blank to use the default of 15 seconds. [/TargetTimeout]
File
Target File
A target file (that is, a .dacpac file) to be used as the target of action instead of a database. [/TargetFile]
...
The name of the target database. [/TargetDatabaseName]
Variables
Variables
Specify one variable per line in the format of variable_name=variable_value. [/Variables:]
Properties
Properties
Specify one property per line in the format of property_name=property_value. The full list of properties can be found at SqlPackage.exe. [/p:]
Options
Logging Verbosity
...