SQL Server

The SQL Server destination allows you to insert rows of data into a table or view within a SQL Server database.

Transfer Complete Actions

•Commit transaction

SQL Server Login Page

The SQL Server Login Page allows a user to enter credentials, select a database, and choose additional options in regards to the insert.

•Connection Tab

oSQL Server Name: The location/address of the SQL Server database.

oAuthentication: The method for signing into the SQL Server database. Windows will attempt to log in with the users Windows Credentials. SQL Server will allow you to manually enter a user name and password for the SQL Server database. Optionally, you can choose to save the password afterwards.

oDatabase Name: The name of the target database which contains the table or view which is to be inserted into.

•Advanced Tab

oConnection Timeout: The amount of time to spend attempting to make a connection to the database. The default time is 15 seconds.

oCommand Timeout: The amount of time to spend attempting to complete the commands or transaction before disconnecting. It is advised to use a higher command timeout if you are inserting a lot of data or working with a slow connection.

oUse Transactions: A transaction is a single unit of work. Enabling transactions allows for an all-or-nothing insert. If any lines encounter a problem, the transaction will roll back and all modifications will be erased. If a transaction is successful, all modifications were successful and become a permanent part of the database.

Database Table Name Page

Using the credentials supplied on the login page, the database will be queried for all tables and views. Select the name of the object you wish to insert into.

Database Mapping Page

The Database Mapping Page is used to map properties and attributes from the source document to columns in the desired object within the SQL Server database. The detected macros list box on the left contains all of the available macros originating from the source document. The detected columns list box contains a list of all of the detected column names within the SQL Server object that was selected on the previous page. These support drag and drop. Drag a column or macro to the column macros data grid and drop. Dropping a column name will create a new row in the data grid with the name of the column. The name of the column cannot be changed. Dragging a macro from the detected macros list box will add the macro to the Column Macro column on the line which it is dropped.

Send comments on this topic.