You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

SQL Package Extract



Source


Connection String


Connection Properties



Properties



Options


Environment





















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. 

  • No labels