Kourier Integrator Online Help
Use this page to view and/or edit the properties of a SSIS Configuration (SQL Server Integration Services) file. Many of these properties will be used as default values on the Generate Package page.
You must have one or more SSIS configuration files available for editing and the proper file system security must be setup to allow saving this file.
|
|
Click the Save icon in the toolbar to close the window and save the entered information to the configuration file. |
|
|
Click the Cancel icon in the toolbar to close the window without saving any changes. |
|
|
Click the Help balloon to open the help for this page. |
This page is intended for advanced users. Take care while entering or editing the information on this page because it is not validated. You must know what to enter for each of the fields below.
Note, this page shows all values that exist in the configuration file being edited and displays them in the order they exist in that file. Therefore, the order of the fields shown below may not match your configuration file. The fields listed below are the primary fields used for SSIS configuration, If any other fields are displayed you should change them at your own risk.
Be sure to enter all path names using UNC format, and make sure those paths are accessible from the server where MS SQL Server is running. See the glossary entry for UNC for more information.
|
Field Name |
Description - Usage - Notes |
|
Configuration File |
Display only field for the configuration file you are currently viewing. |
|
SQL Server |
The name of the server where the SQL Server database is located. |
|
SQL Database |
The name of the SQL Server database you will be updating with the SSIS packages. |
|
Use Windows Authentication |
If you want to use the currently logged in user's username and password for the SSIS package to log into the SQL database, select the Windows Authentication checkbox. There user could be an actual user or a system user (as in the case of a service that is running the package). If you do not select Windows Authentication, SQL Server Authentication will be used and you must enter the username and password to login to the database. |
|
Username |
The username to be used when the SSIS package logs into the SQL database. This is only used if Windows Authentication is not selected. |
|
Password |
The password to be used when the SSIS package logs into the SQL database. This is only used if Windows Authentication is not selected. |
|
DataDirectory |
The valid directory path to a location used to indicate where all data files extracted using the SQL Data Export Specification will be saved. The SSIS packages will look in this location for files that are ready to process and import into SQL Server database. |
|
Debug |
NOT USED |
|
LogDirectory |
The valid directory path to a location where the SSIS packages will save all log and errors files generated while processing packages. |
|
MaxEmailFileSize |
This valued indicated the maximum size of a file (in bytes) that can be attached to an email and successfully delivered. Default value is 5242880 because many email systems have a 5 MB attachment limit. Enter the value that conforms to your system limit. After a SSIS package completes processing, an email is sent to the address specified in the SMTPTo package variable. That email will include an attachment will all the errors if the size of the attachment is less than the value entered here. If the attachment is larger than this value, then the email will be sent with a link the attachment instead. |
|
MaxToleratedErrors |
This value specifies the maximum number of errors allowed while processing a DTS package for a file. Once this limit is reached the DTS package process will stop. Note, this variable is not used by SSIS packages. |
|
SMTPBcc |
This is the valid email address where you would like all e-mails generated by the SSIS package to be blind copied (BCC'd) to. |
|
SMTPCc |
This is the valid email address where you would like all e-mails generated by the SSIS package to be carbon copied (CC'd) to. |
|
SMTPDataMessage |
This is the text to be used as the message body by all e-mails generated by the SSIS package when DATA errors are encountered. |
|
SMTPDataSubject |
This is the subject line to be used by all e-mails generated by the SSIS package when DATA errors are encountered. |
|
SMTPFileMessage |
This is the text to be used as the message body by all e-mails generated by the SSIS package when FILE errors are encountered. |
|
SMTPFileSubject |
This is the subject line to be used by all e-mails generated by the SSIS package when FILE errors are encountered. These e-mails will only be sent if the "Error if import file(s) are not present" option is checked on the Generate Package for SQL Export page. |
|
SMTPFrom |
This is the valid email address that you would like to use as the FROM address when sending e-mails generated by the SSIS package. |
|
SMTPTo |
This is the valid email address where you would like all e-mails generated by the SSIS package to be sent TO. |
|
SMTPServer |
The name of the mail server to use to send SMTP mail. This field is required in order to deliver any error messages generated when processing SSIS packages via e-mail. It may be left blank if you do not want to receive any error messages via e-mail. |
|
LockedFileRetryInterval |
The retry delay (in milliseconds) before the SSIS package will retry to process a locked file in the DataDirectory. |
|
LockedFileRetryAttempts |
This field indicates the number of times to retry processing a locked file before ending the SSIS package. The LockedFileRetryInterval will be double after each retry attempt. |
|
DataDirectoryRetryInterval |
The retry delay (in milliseconds) before the SSIS package will re-attempt to look for the file to be processed in the DataDirectory. On most systems this field should be zero. This setting is useful when the DataDirectory is located on a file system/server that has high file latency. |
|
DataDirectoryRetryAttempts |
This field indicates the number of times to retry processing a locked file before ending the SSIS package. The LockedFileRetryInterval will be double after each retry attempt. |
