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.
oQuery: The select statement to be used to query data from the SQL Server.
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.
Copyright © 2023 pasUNITY, Inc.
Send comments on this topic.