SQL Server Writer Activity¶

Writes specified view to SQL Server table.

Parameters¶

Name	Description	Type	Default
Title	Title of the activity to display on the designer.	text
Host Name	Name or address of the server where SQL Server database is hosted.	text
Port	Port number which SQL Server database is configured with.	int	1433
Database Name	Name of the database.	text
User Name	Valid SQL Server user name. Consider using vault feature with templating (e.g. `${vault:secret-mydb-user}`)	text
Password	Password associated with above user. Consider using vault feature with templating (e.g. `${vault:secret-mydb-password}`)	text
Source View	Name of the DataRow view which is going to be written into the SQL Server table.	text
Bulk Insert	Use bulk insert feature of target database (experimental feature).	boolean	false
Batch Size	Write batch size.	int	1000
Mode	Write mode. Please see blow for list modes and their meanings.	enum	error
As	Target SQL Server table name.	text
Pre Script	SQL script to execute before the data write.	text
Post Script	SQL script to execute after the data write.	text
Options	Additional options.	key-value

Name	Description
error	Fail if table already exists.
append	Append to existing table or create new.
overwrite	Overwrite existing table or create new.
ignore	Ignore if table already exists or create new.