...
Note: At the time of the import operation to an existing database, the target database cannot contain any user-defined schema objects.
SQL Package Import
Name
A friendly name for this action (will be displayed in the actions workflow area).
...
Whether to use a connection string 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]
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
...